Sql - Which date function is used to find the difference between two dates?

[radhika_btech]

Sql - Which date function is used to find the difference between two dates?

[sk_kireeti]

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