Re: adding minutes in oracle

The unit of measurement of a date variable is a day. You need to convert your 10 minutes in a fraction of a day (10/3600) and it will work.

Hth,

Sybrand Bakker, Oracle DBA

"Kreso" <kfutivic_at_delfin.hr> wrote in message news:906aee$c30$1_at_sunce.iskon.hr...
> Hi,
>
> Is there a way to add a 10 minutes at let say, sysdate for example... ?
>
> There is a possibility to convert it with sssss (seconds past midnight)
 and
> add minutes * 60 but on the end of the day it doesnt work :(
>
> I mena, not to convert everything into numbers and write ifs like if
> minutes>60 then hour := hour +1 and stuff
>
>
> please?
>
>
>
>
Received on Thu Nov 30 2000 - 21:04:39 CET