我有类似这样的sql语句:
SELECT EMP_NAME, DEPT
FROM EMPLOYEE
WHERE TIME_CREATED >= TO_DATE('26/JAN/2011','dd/mon/yyyy')
->返回10行,TIME_CREATED = '26-JAN-2011‘
现在,当我这样做的时候,我没有得到任何行,
SELECT EMP_NAME, DEPT
FROM EMPLOYEE
WHERE TIME_CREATED = TO_DATE('26/JAN/2011','dd/mon/yyyy')
->取了大于的值
有什么原因吗?
https://stackoverflow.com/questions/6749369
复制相似问题