帮忙看下to_date的用法
aiq 2009-04-24 01:01:54 select l_code from table1
where (to_date(g_sendtime,'yyyy-mm-dd hh24:mi')-to_date(g_indate,'yyyy-mm-dd hh24:mi') >(1/24/60)*30
以上语法执行正确,但我需要计算count就出错了
select count(*) from table1
where (to_date(g_sendtime,'yyyy-mm-dd hh24:mi')-to_date(g_indate,'yyyy-mm-dd hh24:mi') >(1/24/60)*30
错误是ora-01861:文字与格式字符串不匹配