diff options
| author | Tatiana A. Nurnberg <azundris@mysql.com> | 2008-11-27 12:33:04 +0100 |
|---|---|---|
| committer | Tatiana A. Nurnberg <azundris@mysql.com> | 2008-11-27 12:33:04 +0100 |
| commit | 61296d6db7c6db5eb0f57f61c3d199fe59f2a527 (patch) | |
| tree | b702ee95f5d07603e87bd4dddb4acf6ec9915ed9 /mysql-test/r/func_sapdb.result | |
| parent | 4bf94e7a28e4206e8307362fb2d958369eb8bbd6 (diff) | |
| parent | d096079d330f77eebd3c3abef04236a9a4a08d7b (diff) | |
| download | mariadb-git-61296d6db7c6db5eb0f57f61c3d199fe59f2a527.tar.gz | |
auto-merge
Diffstat (limited to 'mysql-test/r/func_sapdb.result')
| -rw-r--r-- | mysql-test/r/func_sapdb.result | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/mysql-test/r/func_sapdb.result b/mysql-test/r/func_sapdb.result index 942073e3fbd..63f9ac71e74 100644 --- a/mysql-test/r/func_sapdb.result +++ b/mysql-test/r/func_sapdb.result @@ -256,3 +256,15 @@ a select str_to_date("2003-01-02 10:11:12.0012", "%Y-%m-%d %H:%i:%S.%f"); str_to_date("2003-01-02 10:11:12.0012", "%Y-%m-%d %H:%i:%S.%f") 2003-01-02 10:11:12.001200 +select timediff('2008-09-29 20:10:10','2008-09-30 20:10:10'),time('00:00:00'); +timediff('2008-09-29 20:10:10','2008-09-30 20:10:10') time('00:00:00') +-24:00:00 00:00:00 +select timediff('2008-09-29 20:10:10','2008-09-30 20:10:10')>time('00:00:00'); +timediff('2008-09-29 20:10:10','2008-09-30 20:10:10')>time('00:00:00') +0 +select timediff('2008-09-29 20:10:10','2008-09-30 20:10:10')<time('00:00:00'); +timediff('2008-09-29 20:10:10','2008-09-30 20:10:10')<time('00:00:00') +1 +SELECT CAST(time('-73:42:12') AS DECIMAL); +CAST(time('-73:42:12') AS DECIMAL) +-734212 |