Xref: alice comp.databases.oracle.server:73469 comp.databases.oracle.tools:35377
Path: alice!news-feed.fnsi.net!news.maxwell.syr.edu!nntp2.deja.com!nnrp1.deja.com!not-for-mail
From: wmemal@my-deja.com
Newsgroups: comp.databases.oracle.server,comp.databases.oracle.tools
Subject: Re: DATE/time - adding minutes
Date: Thu, 11 Nov 1999 07:31:02 GMT
Organization: Deja.com - Before you buy.
Lines: 27
Message-ID: <80drbn$9at$1@nnrp1.deja.com>
References: <7v78dq$7h2$1@bagan.srce.hr>
X-Article-Creation-Date: Thu Nov 11 07:31:02 1999 GMT
X-Http-User-Agent: Mozilla/4.61 [en] (Win98; I)
X-Http-Proxy: 1.0 relay.coke.kmr.kuzbass.net:3334 (Squid/2.2.STABLE2), 1.0 x35.deja.com:80 (Squid/1.1.22) for client 10.0.0.19, 193.232.88.214
X-MyDeja-Info: XMYDJUIDwmemal

In article <7v78dq$7h2$1@bagan.srce.hr>,
  "keso" <keso@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.