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)
MARKAND911
-1
Junior Poster
Recommended Answers
Jump to Postfollowing 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;
All 3 Replies
urtrivedi
276
Nearly a Posting Virtuoso
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
0
Newbie Poster
select trunc(to_date('01-SEP-2007')-to_date('22-JUN-2007')) as "days between dates" from dual;
kiran
karant
0
Newbie Poster
select to_date('01-SEP-2007')-to_date('22-JUN-2007') as "days between dates" from dual;
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.