diff options
| author | Sergei Golubchik <sergii@pisem.net> | 2011-03-18 13:50:39 +0100 |
|---|---|---|
| committer | Sergei Golubchik <sergii@pisem.net> | 2011-03-18 13:50:39 +0100 |
| commit | db9c46de40549d26fd71e43cee38355f5141c549 (patch) | |
| tree | de1b339ceb6d22c80270dab3f3b2f25d266e811c /mysql-test/r/func_time.result | |
| parent | 5ff5c4b8a32a74501aace277766df4c336c62157 (diff) | |
| download | mariadb-git-db9c46de40549d26fd71e43cee38355f5141c549.tar.gz | |
number to time comparison
Diffstat (limited to 'mysql-test/r/func_time.result')
| -rw-r--r-- | mysql-test/r/func_time.result | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/mysql-test/r/func_time.result b/mysql-test/r/func_time.result index 8f96a9ff5d9..1ada270b326 100644 --- a/mysql-test/r/func_time.result +++ b/mysql-test/r/func_time.result @@ -1358,6 +1358,21 @@ Warning 1292 Truncated incorrect time value: '' Warning 1292 Truncated incorrect time value: '' DROP TABLE t1; End of 5.1 tests +select time('10:10:10') > 10; +time('10:10:10') > 10 +1 +select time('10:10:10') > 1010; +time('10:10:10') > 1010 +1 +select time('10:10:09') > 101010; +time('10:10:09') > 101010 +0 +select time('10:10:10') > 101010; +time('10:10:10') > 101010 +0 +select time('10:10:11') > 101010; +time('10:10:11') > 101010 +1 select time(' 1 02:03:04') + interval 9 microsecond; time(' 1 02:03:04') + interval 9 microsecond 26:03:04.000009 |