Displays the current date formatting style : DATESTYLE « Date Timezone « PostgreSQL






  1. PostgreSQL
  2. Date Timezone
  3. DATESTYLE

Displays the current date formatting style


postgres=# -- Displays the current date formatting style:
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.Setting date formats
3.SET DATESTYLE TO NONEUROPEAN, GERMAN
4.Sets the DATESTYLE variable to use traditional PostgreSQL style formatting