Saturday, 31 August 2013

I am not able to use equality in date query

I am not able to use equality in date query

I am trying to compare a particular date in my SQL query in ORACLE BUT it
is returning a null value. But if I am using greater than or less then it
is working fine. Please check it and revert me with your feedback..
SELECT *
FROM TICK
WHERE stock_id = 7108
AND TRUNC(TICK_date) = To_date('30/08/2013', 'dd/mm/yyyy')

No comments:

Post a Comment