Re: DATE/time - adding minutes
From: <wmemal_at_my-deja.com>
Date: Thu, 11 Nov 1999 07:31:02 GMT
Message-ID: <80drbn$9at$1_at_nnrp1.deja.com>
Date: Thu, 11 Nov 1999 07:31:02 GMT
Message-ID: <80drbn$9at$1_at_nnrp1.deja.com>
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 - 08:31:02 CET