PostgreSQL
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 |
|---|---|
|
Time is before 12:00 |
|
Ignored |
|
Next field is Julian Date |
|
Ignored |
|
Time is on or after 12:00 |
|
Next field is time |
+
| Prev | Up | Next |
|---|---|---|
B.2. Handling of Invalid or Ambiguous Timestamps |
B.4. Date/Time Configuration Files |
Submit correction
If you see anything in the documentation that is not correct, does not match your experience with the particular feature or requires further clarification, please use this form to report a documentation issue.
Copyright © 1996-2023 The PostgreSQL Global Development Group