- publishing free software manuals
The PostgreSQL 9.0 Reference Manual - Volume 1A - SQL Language Reference
by The PostgreSQL Global Development Group
Paperback (6"x9"), 454 pages
ISBN 9781906966041
RRP £14.95 ($19.95)

Sales of this book support the PostgreSQL project! Get a printed copy>>>

12.7 Date/Time Key Words

Table B-1 shows the tokens that are recognized as names of months.

Table B-1: Month Names
Month Abbreviations
January Jan
February Feb
March Mar
April Apr
May
June Jun
July Jul
August Aug
September Sep, Sept
October Oct
November Nov
December Dec

Table B-2 shows the tokens that are recognized as names of days of the week.

Table B-2: Day of the Week Names
Day Abbreviations
Sunday Sun
Monday Mon
Tuesday Tue, Tues
Wednesday Wed, Weds
Thursday Thu, Thur, Thurs
Friday Fri
Saturday Sat

Table B-3 shows the tokens that serve various modifier purposes.

Table B-3: Date/Time Field Modifiers
Identifier Description
AM Time is before 12:00
AT Ignored
JULIAN, JD, J Next field is Julian Day
ON Ignored
PM Time is on or after 12:00
T Next field is time
ISBN 9781906966041The PostgreSQL 9.0 Reference Manual - Volume 1A - SQL Language ReferenceSee the print edition