PostgreSQL/Date Timezone/DATESTYLE

Displays the current date formatting style

postgres=# -- Displays the current date formatting style:
postgres=#
postgres=# SHOW DATESTYLE;
 DateStyle
-----------
 ISO, MDY
(1 row)
postgres=#

SET DATESTYLE TO NONEUROPEAN, GERMAN

postgres=#
postgres=# -- Setting date formats
postgres=#
postgres=# SET DATESTYLE TO NONEUROPEAN, GERMAN;
SET
postgres=#
postgres=# SHOW DATESTYLE;
  DateStyle
-------------
 German, MDY
(1 row)
postgres=#

Sets the date and time formatting to ISO

postgres=#
postgres=# -- Sets the date and time formatting to ISO:
postgres=#
postgres=# SET DATESTYLE TO ISO;
SET
postgres=#
postgres=#

Sets the DATESTYLE variable to use traditional PostgreSQL style formatting

postgres=#
postgres=# -- Sets the DATESTYLE variable to use traditional PostgreSQL style formatting.
postgres=#
postgres=# SET DATESTYLE TO Postgres,US;
SET
postgres=#
postgres=#

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=#