Question Sir I want to retrieve all records between two dates . that is all records between this two dates 16-07-2009 to 16-08-2009 . Please give me more examples on this query
Answer Hi there
Some examples:
select * from dual a
where sysdate between to_date('16/07/2009','dd/mm/yyyy') and to_date('16/08/2009','dd/mm/yyyy')
select * from dual a
where sysdate between to_date(replace('16-07-2009','-','/'),'dd/mm/yyyy') and to_date(replace('16-07-2009','-','/'),'dd/mm/yyyy')