{"id":2478,"date":"2025-03-19T21:05:47","date_gmt":"2025-03-19T14:05:47","guid":{"rendered":"https:\/\/www.pgtutorial.com\/?page_id=2478"},"modified":"2025-03-19T21:08:17","modified_gmt":"2025-03-19T14:08:17","slug":"postgresql-date-format","status":"publish","type":"page","link":"https:\/\/www.pgtutorial.com\/postgresql-date-functions\/postgresql-date-format\/","title":{"rendered":"PostgreSQL Date Format"},"content":{"rendered":"\n

The following table shows the date format you can use to format a date, time, or timestamp:<\/p>\n\n\n\n

Pattern<\/th>Description<\/th><\/tr><\/thead>
Y,YYY<\/strong><\/td>Year in 4 digits with a comma (e.g., 2,025<\/code>)<\/td><\/tr>
YYYY<\/strong><\/td>Year in 4 digits (e.g., 2025<\/code>)<\/td><\/tr>
YYY<\/strong><\/td>Last 3 digits of the year (e.g., 025<\/code> for 2025<\/code>)<\/td><\/tr>
YY<\/strong><\/td>Last 2 digits of the year (e.g., 25<\/code> for 2025<\/code>)<\/td><\/tr>
Y<\/strong><\/td>Last digit of the year (e.g., 5<\/code> for 2025<\/code>)<\/td><\/tr>
IYYY<\/strong><\/td>ISO 8601 week-numbering year in 4 digits<\/td><\/tr>
IYY<\/strong><\/td>Last 3 digits of the ISO 8601 week-numbering year<\/td><\/tr>
IY<\/strong><\/td>Last 2 digits of the ISO 8601 week-numbering year<\/td><\/tr>
I<\/strong><\/td>Last digit of the ISO 8601 week-numbering year<\/td><\/tr>
BC, bc, AD, ad<\/strong><\/td>Era indicator without periods (e.g., BC<\/code>, AD<\/code>)<\/td><\/tr>
B.C., b.c., A.D., a.d.<\/strong><\/td>Era indicator with periods (e.g., B.C.<\/code>, A.D.<\/code>)<\/td><\/tr>
MONTH<\/strong><\/td>Full month name in uppercase (e.g., MARCH<\/code>)<\/td><\/tr>
Month<\/strong><\/td>Full month name with first letter capitalized (e.g., March<\/code>)<\/td><\/tr>
month<\/strong><\/td>Full month name in lowercase (e.g., march<\/code>)<\/td><\/tr>
MON<\/strong><\/td>Abbreviated month name in uppercase (e.g., MAR<\/code>)<\/td><\/tr>
Mon<\/strong><\/td>Abbreviated month name with first letter capitalized (e.g., Mar<\/code>)<\/td><\/tr>
mon<\/strong><\/td>Abbreviated month name in lowercase (e.g., mar<\/code>)<\/td><\/tr>
MM<\/strong><\/td>Month number (01-12)<\/td><\/tr>
DAY<\/strong><\/td>Full weekday name in uppercase (e.g., TUESDAY<\/code>)<\/td><\/tr>
Day<\/strong><\/td>Full weekday name with first letter capitalized (e.g., Tuesday<\/code>)<\/td><\/tr>
day<\/strong><\/td>Full weekday name in lowercase (e.g., tuesday<\/code>)<\/td><\/tr>
DY<\/strong><\/td>Abbreviated weekday name in uppercase (e.g., TUE<\/code>)<\/td><\/tr>
Dy<\/strong><\/td>Abbreviated weekday name with first letter capitalized (e.g., Tue<\/code>)<\/td><\/tr>
dy<\/strong><\/td>Abbreviated weekday name in lowercase (e.g., tue<\/code>)<\/td><\/tr>
DDD<\/strong><\/td>Day of the year (001-366)<\/td><\/tr>
IDDD<\/strong><\/td>Day of the ISO 8601 week-numbering year (001-366)<\/td><\/tr>
DD<\/strong><\/td>Day of the month (01-31)<\/td><\/tr>
D<\/strong><\/td>Day of the week (1 = Sunday, 7 = Saturday)<\/td><\/tr>
ID<\/strong><\/td>ISO 8601 day of the week (1 = Monday, 7 = Sunday)<\/td><\/tr>
W<\/strong><\/td>Week of the month (1-5, where the first week starts on the first day of the month)<\/td><\/tr>
WW<\/strong><\/td>Week number of the year (1-53, where the first week starts on the first day of the year)<\/td><\/tr>
IW<\/strong><\/td>ISO 8601 week number of the year (01-53, where week 1 contains the first Thursday of the year)<\/td><\/tr>
CC<\/strong><\/td>Century (e.g., 21<\/code> for years 2000-2099)<\/td><\/tr>
J<\/strong><\/td>Julian Day (integer days since November 24, 4714 BC, at noon UTC)<\/td><\/tr>
RM<\/strong><\/td>Month in uppercase Roman numerals (I-XII; I<\/code> = January, XII<\/code> = December)<\/td><\/tr>
rm<\/strong><\/td>Month in lowercase Roman numerals (i-xii; i<\/code> = January, xii<\/code> = December)<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n


<\/p>\n

\n\t
\n\t\t
Was this tutorial helpful ?<\/div>\n\t\t
\n\t\t\t\n\t\t\t\t\n\t\t\t\t\t<\/path>\n\t\t\t\t<\/svg>\n\t\t\t\t Yes <\/span>\n\t\t\t<\/button>\n\n\t\t\t\n\t\t\t\t\n\t\t\t\t\t<\/path>\n\t\t\t\t<\/svg>\n\t\t\t\t No <\/span>\n\t\t\t<\/button>\n\t\t<\/div>\n\t<\/header>\n\n\t
\n\t\t
\n\t\t\t
<\/div>\n\t\t\t\n\t\t\t