How to find days between two dates

[musman]

i want to find days between two dates

example

p_from_date = '2009/01/01 HH24:MI:SS'

p_to_date = '2009/12/09 HH24:MI:SS'

How i find exact days between these two dates.

[Kashif]

Code: Select all

Select to_date('2009/12/09','YYYY/MM/DD') - to_date('2009/01/01','YYYY/MM/DD')
from dual

if there is time involved, then use the TRUNC function to get the exact number of days between 2 dates.