Difference between start time and end time

[mrpaulwass]

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