Test the "SET DateStyle TO..." date formatting modes.

1 files changed, 58 insertions, 0 deletions

diff --git a/src/test/regress/sql/horology.sql b/src/test/regress/sql/horology.sql
index bf772e46249..bd06dda52c0 100644
--- a/src/test/regress/sql/horology.sql
+++ b/src/test/regress/sql/horology.sql
@@ -89,3 +89,61 @@ SELECT '' AS six, f1 as reltime, timespan( f1) AS timespan
 
 DROP TABLE TEMP_DATETIME;
 
+--
+-- formats
+--
+
+SET DateStyle TO 'US,Postgres';
+
+SHOW DateStyle;
+
+SELECT '' AS sixty_two, d1 AS us_postgres FROM DATETIME_TBL;
+
+SELECT '' AS eight, f1 AS us_postgres FROM ABSTIME_TBL;
+
+SET DateStyle TO 'US,ISO';
+
+SELECT '' AS sixty_two, d1 AS us_iso FROM DATETIME_TBL;
+
+SELECT '' AS eight, f1 AS us_iso FROM ABSTIME_TBL;
+
+SET DateStyle TO 'US,SQL';
+
+SHOW DateStyle;
+
+SELECT '' AS sixty_two, d1 AS us_sql FROM DATETIME_TBL;
+
+SELECT '' AS eight, f1 AS us_sql FROM ABSTIME_TBL;
+
+SET DateStyle TO 'European,Postgres';
+
+SHOW DateStyle;
+
+INSERT INTO DATETIME_TBL VALUES('13/06/1957');
+
+SELECT count(*) as one FROM DATETIME_TBL WHERE d1 = 'Jun 13 1957';
+
+SELECT '' AS sixty_three, d1 AS european_postgres FROM DATETIME_TBL;
+
+SELECT '' AS eight, f1 AS european_postgres FROM ABSTIME_TBL;
+
+SET DateStyle TO 'European,ISO';
+
+SHOW DateStyle;
+
+SELECT '' AS sixty_three, d1 AS european_iso FROM DATETIME_TBL;
+
+SELECT '' AS eight, f1 AS european_iso FROM ABSTIME_TBL;
+
+SET DateStyle TO 'European,SQL';
+
+SHOW DateStyle;
+
+SELECT '' AS sixty_three, d1 AS european_sql FROM DATETIME_TBL;
+
+SELECT '' AS eight, f1 AS european_sql FROM ABSTIME_TBL;
+
+RESET DateStyle;
+
+SHOW DateStyle;
+