一 日期比较
select datediff('2008-08-08', '2008-08-01');
二 时间比较
TIMEDIFF(A.START_TIME,?)<0
三 字符串转换为时间
select str_to_date('08/09/2008', '%m/%d/%Y') as column_name from SCHEDULE;
select datediff('2008-08-08', '2008-08-01');
二 时间比较
TIMEDIFF(A.START_TIME,?)<0
三 字符串转换为时间
select str_to_date('08/09/2008', '%m/%d/%Y') as column_name from SCHEDULE;