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