diff options
| author | Alexander Barkov <bar@mariadb.com> | 2019-08-22 14:17:04 +0400 |
|---|---|---|
| committer | Alexander Barkov <bar@mariadb.com> | 2019-08-22 15:09:59 +0400 |
| commit | 235cf969d21ba3406a9325d952fda47c589e58d6 (patch) | |
| tree | 850e3fe62f7d4baec24847bd15808402bda48517 /mysql-test/main/func_time.result | |
| parent | 7b4de10477a7bdb51656d827ad2d914d29a4be4c (diff) | |
| download | mariadb-git-235cf969d21ba3406a9325d952fda47c589e58d6.tar.gz | |
MDEV-20397 Support TIMESTAMP, DATETIME, TIME in ROUND() and TRUNCATE()
Diffstat (limited to 'mysql-test/main/func_time.result')
| -rw-r--r-- | mysql-test/main/func_time.result | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/mysql-test/main/func_time.result b/mysql-test/main/func_time.result index 0b5fb46c1d5..a9d4f365f9b 100644 --- a/mysql-test/main/func_time.result +++ b/mysql-test/main/func_time.result @@ -2180,13 +2180,13 @@ CREATE TABLE t1 (a TIMESTAMP(3)); INSERT INTO t1 VALUES ('2001-01-01 10:20:30.999'); SELECT CAST(COALESCE(a,a) AS SIGNED) AS c1, CAST(COALESCE(a,a) AS DECIMAL(25,3)) AS c2, ROUND(COALESCE(a,a)) AS c2 FROM t1; c1 c2 c2 -20010101102030 20010101102030.999 20010101102031 +20010101102030 20010101102030.999 2001-01-01 10:20:31 DROP TABLE t1; CREATE TABLE t1 (a TIME(3)); INSERT INTO t1 VALUES ('10:20:30.999'); SELECT CAST(COALESCE(a,a) AS SIGNED) AS c1, CAST(COALESCE(a,a) AS DECIMAL(25,3)) AS c2, ROUND(COALESCE(a,a)) AS c2 FROM t1; c1 c2 c2 -102030 102030.999 102031 +102030 102030.999 10:20:31 DROP TABLE t1; SELECT CAST(COALESCE(DATE('2001-01-01'),TIMESTAMP('2001-01-02 10:20:30')) AS SIGNED) AS c1, |