Postgresql 中文操作指南
B.3. Date/Time Key Words #
Table B.1 显示了被识别为月份名称的标记。
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 显示了被识别为星期几名称的标记。
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 显示了用于各种修饰目的的标记。
Table B.3. Date/Time Field Modifiers
Identifier |
Description |
AM |
Time is before 12:00 |
AT |
Ignored |
JULIAN, JD, J |
下一个字段是儒略日 |
ON |
Ignored |
PM |
时间在 12:00 或之后 |
T |
Next field is time |