Sql - Which date function is used to find the difference between two dates?
Sql - Which date function is used to find the difference between two dates?
As far as I know, we have only 1 date function which gives difference. That is months_between(latest_date, earlier_date). It gives difference in months.
For more details on date functions, please refer the below post -
Oracle Date Functions
SQL Functions
If you want it in days, or hours or minutes, please refer the below post from asktom-
Getting the difference between dates
Thanks,
Krishna
Last edited by sk_kireeti; 26-01-07 at 03:48 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)