Hello,
i have a table with this structure and i am writing this query for fetching some rows based on some condition , but this query is not returning any data . Can you please tell why ?
ID DT
003 11/8/2011
002 10/8/2011
001 9/8/2011
And the query is :
SELECT * FROM TABLE_NAME WHERE DT BETWEEN TO_DATE('08/08/2011','dd/mm/yyyy') AND TO_DATE('12/08/2011','dd/mm/yyyy');
Edited by: bootstrap on Aug 13, 2011 7:10 AM