Changeset: a53d5a136316 for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=a53d5a136316 Modified Files: sql/test/pg_regress/Tests/horology.sql sql/test/pg_regress/Tests/horology.stable.out Branch: Jul2015 Log Message:
Added setting the time zone at the beginning to get stable output independent of summer/winter time. diffs (32 lines): diff --git a/sql/test/pg_regress/Tests/horology.sql b/sql/test/pg_regress/Tests/horology.sql --- a/sql/test/pg_regress/Tests/horology.sql +++ b/sql/test/pg_regress/Tests/horology.sql @@ -5,6 +5,10 @@ SET australian_timezones = 'off'; SET DateStyle = 'Postgres, MDY'; +-- set time zone to CET +SET TIME ZONE INTERVAL '+1:0' HOUR TO MINUTE; +SELECT CURRENT_TIMEZONE; + -- -- Test various input formats -- diff --git a/sql/test/pg_regress/Tests/horology.stable.out b/sql/test/pg_regress/Tests/horology.stable.out --- a/sql/test/pg_regress/Tests/horology.stable.out +++ b/sql/test/pg_regress/Tests/horology.stable.out @@ -24,6 +24,14 @@ Ready. # 14:44:45 > "mclient" "-lsql" "-ftest" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-25322" "--port=34339" # 14:44:45 > +#SET TIME ZONE INTERVAL '+1:0' HOUR TO MINUTE; +#SELECT CURRENT_TIMEZONE; +% . # table_name +# .L # table_name +% single_value # name +% sec_interval # type +% 8 # length +[ 3600.000 ] #SELECT timestamp with time zone '2001-12-27 04:05:06.789-08'; % .L # table_name % single_value # name _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
