你看我写的这个可以不,应该是可以的 select * from sc002 where substr(to_char(SC0202,'yyyy-MM-dd HH:MM:ss'),1,14)>'2005-03-20 17:32:10';
哦!错了 应该是 select * from sc002 where substr(to_char(SC0202,'yyyy-MM-dd HH:MM:ss'),1,14)>'20050320173210';
select * from sc002 where SC0202>to_date('2005-03-20 17:32:10','yyyy-mm-dd hh24:mi:ss'); 或 select * from sc002 where to_char(SC0202,'yyyy-mm-dd hh24:mi:ss')>'2005-03-20 17:32:10';
select * from sc002 where to_date(SC0202,'YYYY-MM-DD HH24:MI:SS')>to_date('2005-03-20 17:32:10','YYYY-MM-DD HH24:MI:SS');
select * from sc002 where substr(to_char(SC0202,'yyyy-MM-dd HH:MM:ss'),1,14)>'2005-03-20 17:32:10';
应该是
select * from sc002 where substr(to_char(SC0202,'yyyy-MM-dd HH:MM:ss'),1,14)>'20050320173210';
或
select * from sc002 where to_char(SC0202,'yyyy-mm-dd hh24:mi:ss')>'2005-03-20 17:32:10';