--
SET DateStyle TO 'US,Postgres';
SHOW DateStyle;
-NOTICE: DateStyle is Postgres with US (NonEuropean) conventions
+INFO: DateStyle is Postgres with US (NonEuropean) conventions
SELECT '' AS "64", d1 AS us_postgres FROM TIMESTAMP_TBL;
64 | us_postgres
----+-----------------------------
SET DateStyle TO 'US,SQL';
SHOW DateStyle;
-NOTICE: DateStyle is SQL with US (NonEuropean) conventions
+INFO: DateStyle is SQL with US (NonEuropean) conventions
SELECT '' AS "64", d1 AS us_sql FROM TIMESTAMP_TBL;
64 | us_sql
----+------------------------
SET DateStyle TO 'European,Postgres';
SHOW DateStyle;
-NOTICE: DateStyle is Postgres with European conventions
+INFO: DateStyle is Postgres with European conventions
INSERT INTO TIMESTAMP_TBL VALUES('13/06/1957');
SELECT count(*) as one FROM TIMESTAMP_TBL WHERE d1 = 'Jun 13 1957';
one
SET DateStyle TO 'European,ISO';
SHOW DateStyle;
-NOTICE: DateStyle is ISO with European conventions
+INFO: DateStyle is ISO with European conventions
SELECT '' AS "65", d1 AS european_iso FROM TIMESTAMP_TBL;
65 | european_iso
----+------------------------
SET DateStyle TO 'European,SQL';
SHOW DateStyle;
-NOTICE: DateStyle is SQL with European conventions
+INFO: DateStyle is SQL with European conventions
SELECT '' AS "65", d1 AS european_sql FROM TIMESTAMP_TBL;
65 | european_sql
----+------------------------