我的sql语句是
select * from dataloader.gdgzxf t where GZSJ <= TO_DATE('2009-7-23 9:22:54','YYYY-MM-DD')运行异常
Underlying DBMS error[ORA-01830: date format picture ends before converting entire input string
][DATALOADER.GDGZXF]查了许多地方,不知道问题出在哪里?
请高手指点
select * from dataloader.gdgzxf t where GZSJ <= TO_DATE('2009-7-23 9:22:54','YYYY-MM-DD')运行异常
Underlying DBMS error[ORA-01830: date format picture ends before converting entire input string
][DATALOADER.GDGZXF]查了许多地方,不知道问题出在哪里?
请高手指点
select * from dataloader.gdgzxf t where GZSJ <= TO_DATE('2009-7-23','YYYY-MM-DD')
select * from dataloader.gdgzxf t where GZSJ <= TO_DATE('2009-7-23 9:22:54','YYYY-MM-DD HH:MI:SS')
TO_DATE('2009-7-23 9:22:54','YYYY-MM-DD')
两个对应不上
TO_DATE('2009-07-23','YYYY-MM-DD')
或
TO_DATE('2009-07-23 09:22:54','YYYY-MM-DD HH24:MI:SS')