diff options
Diffstat (limited to 'mysql-test/suite/sys_vars/r/time_zone_func.result')
-rw-r--r-- | mysql-test/suite/sys_vars/r/time_zone_func.result | 20 |
1 files changed, 10 insertions, 10 deletions
diff --git a/mysql-test/suite/sys_vars/r/time_zone_func.result b/mysql-test/suite/sys_vars/r/time_zone_func.result index 2153a3f58ff..684c1ec80f4 100644 --- a/mysql-test/suite/sys_vars/r/time_zone_func.result +++ b/mysql-test/suite/sys_vars/r/time_zone_func.result @@ -55,7 +55,7 @@ SET @@time_zone = 'MET'; SELECT a,UNIX_TIMESTAMP(a) FROM t1; a UNIX_TIMESTAMP(a) 2008-03-05 16:28:00 1204730880 -1970-01-01 00:05:00 0 +1970-01-01 00:05:00 NULL 1970-01-01 01:05:00 300 SELECT a,UNIX_TIMESTAMP(a) FROM t2; a UNIX_TIMESTAMP(a) @@ -68,8 +68,8 @@ SET @@time_zone = '+05:00'; SELECT a,UNIX_TIMESTAMP(a) FROM t1; a UNIX_TIMESTAMP(a) 2008-03-05 16:28:00 1204716480 -1970-01-01 00:05:00 0 -1970-01-01 01:05:00 0 +1970-01-01 00:05:00 NULL +1970-01-01 01:05:00 NULL SELECT a,UNIX_TIMESTAMP(a) FROM t2; a UNIX_TIMESTAMP(a) 2008-03-05 21:28:00 1204734480 @@ -81,8 +81,8 @@ SET @@time_zone = '+06:00'; SELECT a,UNIX_TIMESTAMP(a) FROM t1; a UNIX_TIMESTAMP(a) 2008-03-05 16:28:00 1204712880 -1970-01-01 00:05:00 0 -1970-01-01 01:05:00 0 +1970-01-01 00:05:00 NULL +1970-01-01 01:05:00 NULL SELECT a,UNIX_TIMESTAMP(a) FROM t2; a UNIX_TIMESTAMP(a) 2008-03-05 22:28:00 1204734480 @@ -94,7 +94,7 @@ SET @@time_zone = '+01:00'; SELECT a,UNIX_TIMESTAMP(a) FROM t1; a UNIX_TIMESTAMP(a) 2008-03-05 16:28:00 1204730880 -1970-01-01 00:05:00 0 +1970-01-01 00:05:00 NULL 1970-01-01 01:05:00 300 SELECT a,UNIX_TIMESTAMP(a) FROM t2; a UNIX_TIMESTAMP(a) @@ -107,8 +107,8 @@ SET @@time_zone = '+02:00'; SELECT a,UNIX_TIMESTAMP(a) FROM t1; a UNIX_TIMESTAMP(a) 2008-03-05 16:28:00 1204727280 -1970-01-01 00:05:00 0 -1970-01-01 01:05:00 0 +1970-01-01 00:05:00 NULL +1970-01-01 01:05:00 NULL SELECT a,UNIX_TIMESTAMP(a) FROM t2; a UNIX_TIMESTAMP(a) 2008-03-05 18:28:00 1204734480 @@ -133,8 +133,8 @@ SET @@time_zone = '+06:00'; SELECT a,UNIX_TIMESTAMP(a) FROM t1; a UNIX_TIMESTAMP(a) 2008-03-05 16:28:00 1204712880 -1970-01-01 00:05:00 0 -1970-01-01 01:05:00 0 +1970-01-01 00:05:00 NULL +1970-01-01 01:05:00 NULL SELECT a,UNIX_TIMESTAMP(a) FROM t2; a UNIX_TIMESTAMP(a) 2008-03-05 22:28:00 1204734480 |