HTMLDB Engine : Oracle Apex
Alles in HTMLDB, Applikationen, Berichte, SQL ...
Re: Uhrzeitenberechnung, rechnen und ausgeben von Variablen (PL/SQL)
geschrieben von:
cc13 (Moderator)
Datum:
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]
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]
