历史版本。 PostgreSQL 9.1 已结束支持。 2016-10-27. 请参阅 当前版本手册.
B.2. Date/Time Key Words #
表 B.1展示了哪些词元会被识别为月份名称。
表 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 |
表 B.2展示了哪些词元会被识别为星期名称。
表 B.2. 星期名称
| Day | Abbreviations |
|---|---|
| Sunday | Sun |
| Monday | Mon |
| Tuesday | Tue, Tues |
| Wednesday | Wed, Weds |
| Thursday | Thu, Thur, Thurs |
| Friday | Fri |
| Saturday | Sat |
表 B.3展示了用于各种修饰用途的词元。
表 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 |