Schau dir mal dieses Beispiel an. Vielleicht hilft es dir weiter:

SELECT (TO_DATE (TO_CHAR (SYSTIMESTAMP, 'dd/mm/yyyy hh24:mi:ss'),
'dd/mm/yyyy hh24:mi:ss'
)-TO_DATE (TO_CHAR (SYSTIMESTAMP-4, 'dd/mm/yyyy hh24:mi:ss'),
'dd/mm/yyyy hh24:mi:ss'
))*(24*60)
test
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]