B.3. 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 Date |
ON | Ignored |
PM | Time is on or after 12:00 |
T | Next field is time |
© 1996–2019 The PostgreSQL Global Development Group
Licensed under the PostgreSQL License.
https://www.postgresql.org/docs/9.6/datetime-keywords.html