Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: DATE/time - adding minutes
In article <7v78dq$7h2$1_at_bagan.srce.hr>,
"keso" <keso_at_hep.tel.fer.hr> wrote:
>
> What is the simplest method of calculating DATE that is e.g. 15
minutes
> after specified DATE/time?
>
> Is it really necessary to write function similar to ADD_MONTHS:
>
> FUNCTION ADD_MINUTES (d DATE, mi number) return DATE is /* d = d +
mi
*/
> ...
>
> thanks,
>
> Vedran
In my mind, it must be so
FUNCTIONS ADD_MINUTES(d DATE, mi number) RETURN DATE
IS
BEGIN
RETURN (d + mi *(1/(24*60));
END;
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Thu Nov 11 1999 - 01:31:02 CST