我在银泰表中有一些数据,如2012/05/01 09:412012/05/05 09:472012/05/07塔利班)2012/05/09时间为2012/05/10 09:41,
因为我想要的数据像大于2012/05/01 09:30查询将像
您需要将varchar2
列转换为date
列,然后进行比较。你需要这样使用它:
SELECT TO_DATE (Intime, 'YYYY/MM/DD HH:MI') D_ATE
FROM TABLE
WHERE to_date(Intime ,'YYYY/MM/DD HH:MI') > to_date('2012/05/01 09:30','YYYY/MM/DD HH:MI');
演示: with dt_tbl (Intime) as ( select '2012/05/01 09:30' from dual
UNION ALL
select '2012/05/01 09:42' from dual
UNION ALL
select '2012/05/01 09:29' from dual
UNION ALL
select '2012/05/01 09:35' from dual)
SELECT TO_DATE (Intime, 'YYYY/MM/DD HH:MI') D_ATE
FROM dt_tbl
WHERE to_date(Intime ,'YYYY/MM/DD HH:MI') > to_date('2012/05/01 09:30','YYYY/MM/DD HH:MI');