Expert: Edson - 8/16/2009

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')