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