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.
How to find days between two dates
Code: Select all
Select to_date('2009/12/09','YYYY/MM/DD') - to_date('2009/01/01','YYYY/MM/DD')
from dual
Who is online
Users browsing this forum: No registered users and 6 guests