scott@[local]:5432 scottdb#SQL> show datestyle;
DateStyle
-----------
ISO, YMD
(1 row)
Time: 0.210 ms
scott@[local]:5432 scottdb#SQL> select cast('1997-02-01' as date), cast('1997-02-01' as timestamp);
date | timestamp
------------+---------------------
1997-02-01 | 1997-02-01 00:00:00
(1 row)
Time: 0.184 ms
scott@[local]:5432 scottdb#SQL> set datestyle to 'US, SQL';
SET
Time: 8.321 ms
scott@[local]:5432 scottdb#SQL> show datestyle;
DateStyle
-----------
SQL, MDY
(1 row)
Time: 0.147 ms
scott@[local]:5432 scottdb#SQL> select cast('1997-02-01' as date), cast('1997-02-01' as timestamp);
date | timestamp
------------+---------------------
02/01/1997 | 02/01/1997 00:00:00
(1 row)
Time: 0.178 ms
scott@[local]:5432 scottdb#SQL>
