diff options
| author | Sergei Golubchik <sergii@pisem.net> | 2011-05-26 18:11:26 +0200 |
|---|---|---|
| committer | Sergei Golubchik <sergii@pisem.net> | 2011-05-26 18:11:26 +0200 |
| commit | 34c9428871a095ad72e629be843443cef4d7052f (patch) | |
| tree | 4f0f661e9f7e28b25bda36c5e6927a6cbdf8430d /mysql-test/r/func_time_hires.result | |
| parent | 306ed65302e14f303fdc33cfa9d19016fb319440 (diff) | |
| download | mariadb-git-34c9428871a095ad72e629be843443cef4d7052f.tar.gz | |
fix for double or decimal to datetime conversion
Diffstat (limited to 'mysql-test/r/func_time_hires.result')
| -rw-r--r-- | mysql-test/r/func_time_hires.result | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/mysql-test/r/func_time_hires.result b/mysql-test/r/func_time_hires.result index 0def9625b37..1528bd81a6c 100644 --- a/mysql-test/r/func_time_hires.result +++ b/mysql-test/r/func_time_hires.result @@ -87,6 +87,11 @@ Warning 1292 Truncated incorrect time value: '-3020399.9999999' select 20010101000203.000000004 + interval 1 day; 20010101000203.000000004 + interval 1 day 2001-01-02 00:02:03.000000 +Warnings: +Warning 1292 Truncated incorrect datetime value: '20010101000203.000000004' +select 20010101000203.4 + interval 1 day; +20010101000203.4 + interval 1 day +2001-01-02 00:02:03.4 set @a=cast('2011-01-02 12:13:14' as datetime); select @a + interval 1 minute; @a + interval 1 minute |