Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: DATE/time - adding minutes

Re: DATE/time - adding minutes

From: mdimper <mdimperNOmdSPAM_at_hotmail.com.invalid>
Date: Wed, 27 Oct 1999 10:46:35 -0700
Message-ID: <0237dd28.febc473f@usw-ex0101-008.remarq.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

When you add something to a date, you add days, so if you use 1/24/60*mins you get the fraction of day to add

Received on Wed Oct 27 1999 - 12:46:35 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US