diff options
| author | unknown <jani@ua141d10.elisa.omakaista.fi> | 2006-05-04 19:31:10 +0300 |
|---|---|---|
| committer | unknown <jani@ua141d10.elisa.omakaista.fi> | 2006-05-04 19:31:10 +0300 |
| commit | bcb61e6860ae71cbc7e07cc5c956da1542bf5db8 (patch) | |
| tree | 046b31757f6d6f6d3dd1147f95989bc7b9733343 /mysql-test/r/date_formats.result | |
| parent | ac94170069e4de0447fa5b76a1e38a437a66a197 (diff) | |
| download | mariadb-git-bcb61e6860ae71cbc7e07cc5c956da1542bf5db8.tar.gz | |
Fix for Bug#11326.
mysql-test/r/date_formats.result:
Added test cases for Bug#11326
mysql-test/t/date_formats.test:
Added test cases for Bug#11326
Diffstat (limited to 'mysql-test/r/date_formats.result')
| -rw-r--r-- | mysql-test/r/date_formats.result | 18 |
1 files changed, 18 insertions, 0 deletions
diff --git a/mysql-test/r/date_formats.result b/mysql-test/r/date_formats.result index 014eeed27e7..edfe17b0cb4 100644 --- a/mysql-test/r/date_formats.result +++ b/mysql-test/r/date_formats.result @@ -473,3 +473,21 @@ NULL select str_to_date( 1, IF(1=1,NULL,NULL) ); str_to_date( 1, IF(1=1,NULL,NULL) ) NULL +SELECT TIME_FORMAT("24:00:00", '%r'); +TIME_FORMAT("24:00:00", '%r') +12:00:00 AM +SELECT TIME_FORMAT("00:00:00", '%r'); +TIME_FORMAT("00:00:00", '%r') +12:00:00 AM +SELECT TIME_FORMAT("12:00:00", '%r'); +TIME_FORMAT("12:00:00", '%r') +12:00:00 PM +SELECT TIME_FORMAT("15:00:00", '%r'); +TIME_FORMAT("15:00:00", '%r') +03:00:00 PM +SELECT TIME_FORMAT("01:00:00", '%r'); +TIME_FORMAT("01:00:00", '%r') +01:00:00 AM +SELECT TIME_FORMAT("25:00:00", '%r'); +TIME_FORMAT("25:00:00", '%r') +01:00:00 AM |