Date difference

[MARKAND911]

How to calculate no of days between two dates?

eg: how i can calculate number of days between 1/12/2009 and 10/06/2010.(dd/mm/yyyy)

[urtrivedi]

following queries gives difference in days.

select sysdate-to_date('03-jun-2010') from dual;

or

here date1,date2 are fields of date datatype.

select date2-date1 from sometable;

[karant]

select trunc(to_date('01-SEP-2007')-to_date('22-JUN-2007')) as "days between dates" from dual;

kiran

[karant]

select to_date('01-SEP-2007')-to_date('22-JUN-2007') as "days between dates" from dual;