diff options
| author | Alexander Barkov <bar@mnogosearch.org> | 2013-09-12 21:31:14 +0400 |
|---|---|---|
| committer | Alexander Barkov <bar@mnogosearch.org> | 2013-09-12 21:31:14 +0400 |
| commit | 499ddea5766d988adc858448c8eec549c7bedcc1 (patch) | |
| tree | fd0a976fc3ac2b96c8f812c1bab2e0e57976cfce /mysql-test/r/timezone.result | |
| parent | c2b38529a9ca2ea09dfa73186d9350a0d6dcd6ac (diff) | |
| download | mariadb-git-499ddea5766d988adc858448c8eec549c7bedcc1.tar.gz | |
MDEV-4724 Some temporal functions do not preserve microseconds
Diffstat (limited to 'mysql-test/r/timezone.result')
| -rw-r--r-- | mysql-test/r/timezone.result | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/mysql-test/r/timezone.result b/mysql-test/r/timezone.result index 5ae7e6f8117..d84fe54ba8c 100644 --- a/mysql-test/r/timezone.result +++ b/mysql-test/r/timezone.result @@ -7,7 +7,7 @@ select @a:=FROM_UNIXTIME(1); 1970-01-01 01:00:01 select unix_timestamp(@a); unix_timestamp(@a) -1.000000 +1 CREATE TABLE t1 (ts int); INSERT INTO t1 (ts) VALUES (Unix_timestamp('2002-10-27 01:00')); INSERT INTO t1 (ts) VALUES (Unix_timestamp('2002-10-27 02:00')); @@ -44,7 +44,7 @@ unix_timestamp('1970-01-01 01:00:01'), unix_timestamp('2038-01-19 04:14:07'), unix_timestamp('2038-01-19 04:14:08'); unix_timestamp('1970-01-01 01:00:00') unix_timestamp('1970-01-01 01:00:01') unix_timestamp('2038-01-19 04:14:07') unix_timestamp('2038-01-19 04:14:08') -0.000000 1.000000 2147483647.000000 NULL +0 1 2147483647 NULL select unix_timestamp('1969-12-31 23:59:59'), unix_timestamp('1970-01-01 00:00:00'), unix_timestamp('1970-01-01 00:59:59'); unix_timestamp('1969-12-31 23:59:59') unix_timestamp('1970-01-01 00:00:00') unix_timestamp('1970-01-01 00:59:59') NULL NULL NULL |