- publishing free software manuals
PostgreSQL Reference Manual - Volume 1 - SQL Language Reference
by The PostgreSQL Global Development Group
Paperback (6"x9"), 716 pages
ISBN 0954612027
RRP £32.00 ($49.95)

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

14.9 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
ABSTIME Ignored
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

The key word ABSTIME is ignored for historical reasons: In very old releases of PostgreSQL, invalid values of type abstime were emitted as Invalid Abstime. This is no longer the case however and this key word will likely be dropped in a future release.

ISBN 0954612027PostgreSQL Reference Manual - Volume 1 - SQL Language ReferenceSee the print edition