diff options
Diffstat (limited to 'mysql-test/t/func_time.test')
| -rw-r--r-- | mysql-test/t/func_time.test | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/mysql-test/t/func_time.test b/mysql-test/t/func_time.test index 96bdb547469..f1a24a4c3cb 100644 --- a/mysql-test/t/func_time.test +++ b/mysql-test/t/func_time.test @@ -224,6 +224,19 @@ select date_add(date,INTERVAL "1 1:1:1" DAY_SECOND) from t1; select date_add(time,INTERVAL 1 SECOND) from t1; drop table t1; +# test for last_day +select last_day('2000-02-05') as f1, last_day('2002-12-31') as f2, + last_day('2003-03-32') as f3, last_day('2003-04-01') as f4, + last_day('2001-01-01 01:01:01') as f5, last_day(NULL), + last_day('2001-02-12'); + +create table t1 select last_day('2000-02-05') as a; +describe t1; +select * from t1; +drop table t1; +select last_day('2000-02-05'); + + # Test SAPDB UTC_% functions. This part is TZ dependant (It is supposed that # TZ variable set to GMT-3 select strcmp(date_sub(localtimestamp(), interval 3 hour), utc_timestamp())=0; |