Wendlandt, Guido wrote:

> 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.

to_date('27.06.2006 13:22:12','dd.mm.yyyy hh24:mi:ss') -
to_date('25.06.2006 12:48:50','dd.mm.yyyy hh24:mi:ss') gives you the
result in days, i.e. 2.0231713.

If you wish to get the result in minutes you have to multiply this
result for the number of minutes in a day, i.e. 24*60.

HTH. Kind regards,

--
Cristian Veronesi - C.R.P.A. S.p.A. - Reggio Emilia, Italy

The first thing you need to learn about databases is that
they are not just a fancy file system for storing data.




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