-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Wendlandt, Guido schrieb am 04.07.2006 11:46:
> 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
>
>
>
>
>
>
>
>

Guido,

maybe function TRUNC() can help you? http://www.dbforums.com/t1088701.html
speaks about this, and googling for oracle trunc will give many results.

HTH,
Werner

- --
Werner Flamme, Abt. WKDV
UFZ Umweltforschungszentrum Leipzig-Halle GmbH,
Permoserstr. 15 - 04318 Leipzig
Tel.: (0341) 235-3921 - Fax (0341) 235-453921
http://www.ufz.de - eMail: werner.flamme@(protected)




-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.2 (GNU/Linux)
Comment: Using GnuPG with SUSE - http://enigmail.mozdev.org

iD8DBQFEqj4Tk33Krq8b42MRAizeAJ9y16UeWX+ucLyQH/O7CjH0UjxhDwCghhWp
30jfD3UPSgTivvBdP1y2wEg=
=VBy5
-----END PGP SIGNATURE-----

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