Table B.1, “Month Names” 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, “Day of the Week Names” 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, “Date/Time Field Modifiers” 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.