diff options
| author | unknown <gluh@gluh.mysql.r18.ru> | 2003-11-17 18:02:08 +0400 |
|---|---|---|
| committer | unknown <gluh@gluh.mysql.r18.ru> | 2003-11-17 18:02:08 +0400 |
| commit | ac584b24340a6abdce56a62e370feb1d51343488 (patch) | |
| tree | 1938e6b15b2f83f5ed4daaaf3037a102080b9eb6 /mysql-test/t/func_time.test | |
| parent | 9dbaca650210a6eaac3e89cc0e219a2398fb58f5 (diff) | |
| download | mariadb-git-ac584b24340a6abdce56a62e370feb1d51343488.tar.gz | |
WL#1253: LAST_DAY
mysql-test/r/func_time.result:
Test for WL#1253: LAST_DAY
mysql-test/t/func_time.test:
Test for WL#1253: LAST_DAY
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; |