PostgreSQL

B.3. Date/Time Key Words
Prev	Up	Appendix B. Date/Time Support	Home	Next

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

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

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

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

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

Prev	Up	Next
B.2. Handling of Invalid or Ambiguous Timestamps	Home	B.4. Date/Time Configuration Files

B.2. Handling of Invalid or Ambiguous Timestamps

Home

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.