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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Adding to Time in Date fields

Re: Adding to Time in Date fields

From: Neill Atkins <natkins_at_uk.oracle.com>
Date: 1996/12/05
Message-ID: <01bbe209$893426a0$4092038a@ukp2394.uk.oracle.com>#1/1

Could always write your own function ?

-- 
Neill Atkins

Me, Myself I , Opinions Ltd.
Oracle Corporation, UK

Marc <marc_at_popmail.med.nyu.edu> wrote in article
<32A440DF.3F1_at_popmail.med.nyu.edu>...

> I would like to add a certain number of minutes to
> a time value stored in an Oracle Date field.
>
> Is there an Oracle function to allow me to add the minutes
> to the field so that the other members of the Date field "day, hour,
> minutes" will reflect the change?
>
> So if I were to add 20 minutes to "December 2, 1996 12:50AM"
> the resulting Oracle field would be "December 3, 1996 1:10AM"
>
> Thanks,
> Marc Waldman
> marc_at_popmail.med.nyu.edu
>
Received on Thu Dec 05 1996 - 00:00:00 CST

Original text of this message

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