Schau dir mal dieses Select an:
select 24 * (to_date('2009-07-07 22:00', 'YYYY-MM-DD hh24:mi')
- to_date('2009-07-07 19:30', 'YYYY-MM-DD hh24:mi')) diff_hours
from dual;
--
Best regards,
Carsten mailto:carsten.cerny@cc13.com
My private gallery and blog [
cc13.com]
NEU: Meetup-Gruppe Oracle Apex Nürnberg [
www.meetup.com]