Any date calculation is in days. I.e. you have to multiply your result by 24 and then by 60 to get the result in minutes.

SQL> select (to_date('27.06.2006 13:22:12', 'dd.mm.yyyy hh24:mi:ss')
2       -  to_date('25.06.2006 12:48:50', 'dd.mm.yyyy hh24:mi:ss')) * 24 * 60 diff_in_minutes
3 from dual;

DIFF_IN_MINUTES
---------------
  2913.36667


Clemens

--- Originalnachricht ---
> Hi,
>
> How can I calculate the difference between two date / time
> values like this:
>
> 27.06.2006 13:22:12, 'dd.mm.yyyy hh24:mi:ss'  -  25.06.2006
> 12:48:50,
> 'dd.mm.yyyy hh24:mi:ss'   = result in minutes.
>
>
>
> Thank you for answering
>
>
>
> Mit freundlichen Grüßen / Yours sincerly
>
>
>
> Guido Wendlandt
>
>
>
>
>
> ________________________________________________
>
> Georgsmarienhütte GmbH
>
> Neue Hüttenstraße 1
>
> 49124 Georgsmarienhütte
>
> Tel.: +49-(0)5401-394723
>
> FAX: +49-(0)5401-394598
>
> Mobil: +49-(0)170-7857345
>
> <http://www.gmh.de> http://www.gmh.de
>
>
>
>
>
>
>
>


--
To unsubscribe, email: suse-oracle-unsubscribe@(protected)
For additional commands, email: suse-oracle-help@(protected)
Please see http://www.suse.com/oracle/ before posting