@@ -2341,7 +2341,11 @@ DROP TABLE TEMP_TIMESTAMP;
23412341--
23422342SET DateStyle TO 'US,Postgres';
23432343SHOW DateStyle;
2344- INFO: DateStyle is Postgres with US (NonEuropean) conventions
2344+ datestyle
2345+ --------------------------------------------
2346+ Postgres with US (NonEuropean) conventions
2347+ (1 row)
2348+
23452349SELECT '' AS "64", d1 AS us_postgres FROM TIMESTAMP_TBL;
23462350 64 | us_postgres
23472351----+-----------------------------
@@ -2507,7 +2511,11 @@ SELECT '' AS seven, f1 AS us_iso FROM ABSTIME_TBL;
25072511
25082512SET DateStyle TO 'US,SQL';
25092513SHOW DateStyle;
2510- INFO: DateStyle is SQL with US (NonEuropean) conventions
2514+ datestyle
2515+ ---------------------------------------
2516+ SQL with US (NonEuropean) conventions
2517+ (1 row)
2518+
25112519SELECT '' AS "64", d1 AS us_sql FROM TIMESTAMP_TBL;
25122520 64 | us_sql
25132521----+------------------------
@@ -2591,7 +2599,11 @@ SELECT '' AS seven, f1 AS us_sql FROM ABSTIME_TBL;
25912599
25922600SET DateStyle TO 'European,Postgres';
25932601SHOW DateStyle;
2594- INFO: DateStyle is Postgres with European conventions
2602+ datestyle
2603+ ------------------------------------
2604+ Postgres with European conventions
2605+ (1 row)
2606+
25952607INSERT INTO TIMESTAMP_TBL VALUES('13/06/1957');
25962608SELECT count(*) as one FROM TIMESTAMP_TBL WHERE d1 = 'Jun 13 1957';
25972609 one
@@ -2683,7 +2695,11 @@ SELECT '' AS seven, f1 AS european_postgres FROM ABSTIME_TBL;
26832695
26842696SET DateStyle TO 'European,ISO';
26852697SHOW DateStyle;
2686- INFO: DateStyle is ISO with European conventions
2698+ datestyle
2699+ -------------------------------
2700+ ISO with European conventions
2701+ (1 row)
2702+
26872703SELECT '' AS "65", d1 AS european_iso FROM TIMESTAMP_TBL;
26882704 65 | european_iso
26892705----+------------------------
@@ -2768,7 +2784,11 @@ SELECT '' AS seven, f1 AS european_iso FROM ABSTIME_TBL;
27682784
27692785SET DateStyle TO 'European,SQL';
27702786SHOW DateStyle;
2771- INFO: DateStyle is SQL with European conventions
2787+ datestyle
2788+ -------------------------------
2789+ SQL with European conventions
2790+ (1 row)
2791+
27722792SELECT '' AS "65", d1 AS european_sql FROM TIMESTAMP_TBL;
27732793 65 | european_sql
27742794----+------------------------