Setting date formats : DATESTYLE « Date Timezone « PostgreSQL






  1. PostgreSQL
  2. Date Timezone
  3. DATESTYLE

Setting date formats


postgres=#
postgres=# -- Setting date formats
postgres=#
postgres=# SET DATESTYLE TO ISO,US;
SET
postgres=#
postgres=# SHOW DATESTYLE;
 DateStyle
-----------
 ISO, MDY
(1 row)

postgres=#








Related examples in the same category

1.Sets the date and time formatting to ISO
2.SET DATESTYLE TO NONEUROPEAN, GERMAN
3.Displays the current date formatting style
4.Sets the DATESTYLE variable to use traditional PostgreSQL style formatting