From 4adf180432bba0e2f7e67ecb8fa5aa6d9ed86bdb Mon Sep 17 00:00:00 2001 From: unknown Date: Tue, 8 Jul 2003 15:06:05 +0500 Subject: SAPDB date/time finctions mysql-test/r/cast.result: Changes for SAPDB date/time finctions --- mysql-test/t/func_sapdb.test | 6 ++++-- 1 file changed, 4 insertions(+), 2 deletions(-) (limited to 'mysql-test/t/func_sapdb.test') diff --git a/mysql-test/t/func_sapdb.test b/mysql-test/t/func_sapdb.test index 05e1f20fe1e..afd84fe9630 100644 --- a/mysql-test/t/func_sapdb.test +++ b/mysql-test/t/func_sapdb.test @@ -51,7 +51,7 @@ select timediff("1997-01-01 23:59:59.000001","1995-12-31 23:59:59.000002"); select timediff("1997-12-31 23:59:59.000001","1997-12-30 01:01:01.000002"); select timediff("1997-12-30 23:59:59.000001","1997-12-31 23:59:59.000002"); select timediff("1997-12-31 23:59:59.000001","23:59:59.000001"); -select timediff("2000:01:01 00:00:00", "2000:01:01 00:00:00.1"); +select timediff("2000:01:01 00:00:00", "2000:01:01 00:00:00.000001"); select maketime(10,11,12); select maketime(25,11,12); @@ -61,6 +61,8 @@ select maketime(-25,11,12); select timestamp("2001-12-01", "01:01:01.999999"); select timestamp("2001-13-01", "01:01:01.000001"); select timestamp("2001-12-01", "25:01:01"); +select timestamp("2001-12-01 01:01:01.000100"); +select timestamp("2001-12-01"); select day("1997-12-31 23:59:59.000001"); select date("1997-12-31 23:59:59.000001"); select date("1997-13-31 23:59:59.000001"); @@ -75,7 +77,7 @@ select makedate(1997,1) as f1, timediff("1997-12-31 23:59:59.000001","1997-12-30 01:01:01.000002") as f4, timediff("1997-12-30 23:59:59.000001","1997-12-31 23:59:59.000002") as f5, maketime(10,11,12) as f6, - timestamp("2001-12-01", "01:01:01") as f7, + timestamp(cast("2001-12-01" as date), "01:01:01") as f7, date("1997-12-31 23:59:59.000001") as f8, time("1997-12-31 23:59:59.000001") as f9; describe t1; -- cgit v1.2.1