| 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 9781906966041 | The PostgreSQL 9.0 Reference Manual - Volume 1A - SQL Language Reference | See the print edition |