USE tpch1;
select cdate, cdatetime, TIMEDIFF(CDATETIME,'2007-02-28 22:23:0') from datatypetestm where TIMEDIFF(CDATETIME,'2007-02-28 22:23:0') > 0;
cdate	cdatetime	TIMEDIFF(CDATETIME,'2007-02-28 22:23:0')
2009-12-28	2009-12-31 23:59:56	838:59:59
2009-12-29	2009-12-31 23:59:57	838:59:59
2009-12-30	2009-12-31 23:59:58	838:59:59
2009-12-31	2009-12-31 23:59:59	838:59:59
2009-12-31	2009-12-31 23:59:59	838:59:59
2009-12-31	2009-12-31 23:59:59	838:59:59
select cdate, cdatetime, TIMEDIFF(CDATETIME,'2007-02-28 22:23:0') from datatypetestm where TIMEDIFF(CDATETIME,'2007-02-28 22:23:0') = 0;
cdate	cdatetime	TIMEDIFF(CDATETIME,'2007-02-28 22:23:0')
select cdate, cdatetime, TIMEDIFF(CDATETIME,'2007-02-28 22:23:0') from datatypetestm where TIMEDIFF(CDATETIME,'2007-02-28 22:23:0') < 0;
cdate	cdatetime	TIMEDIFF(CDATETIME,'2007-02-28 22:23:0')
1997-01-01	1997-01-01 00:00:00	-838:59:59
1997-01-01	1997-01-01 00:00:01	-838:59:59
1997-01-02	1997-01-02 00:00:01	-838:59:59
1997-01-03	1997-01-03 00:00:02	-838:59:59
1997-01-04	1997-01-04 00:00:03	-838:59:59