Re: adding minutes in oracle
From: Eric Givler <egivler_at_flash.net>
Date: Sun, 03 Dec 2000 03:04:17 GMT
Message-ID: <RKiW5.25761$6W1.1429971_at_news.flash.net>
Date: Sun, 03 Dec 2000 03:04:17 GMT
Message-ID: <RKiW5.25761$6W1.1429971_at_news.flash.net>
ADD THE FRACTION PART OF THE DAY:
+ 10 * 60 / (24 * 60 * 60 )
(10 minutes * 60 seconds/minute ) / (24 hours * 60 min/hr * 60 sec/min)
"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 Sun Dec 03 2000 - 04:04:17 CET