How can I calculate the difference (in seconds/mins/etc) between to dates?
Thanks,
P
Printable View
How can I calculate the difference (in seconds/mins/etc) between to dates?
Thanks,
P
This works.
SELECT (to_date('08:10:45','hh:mi:ss')-to_date('08:10:15','hh:mi:ss'))*24*60*60
FROM dual
Thanks,
P