Re: Adding to Time in Date fields
From: Neill Atkins <natkins_at_uk.oracle.com>
Date: 1996/12/05
Message-ID: <01bbe209$893426a0$4092038a_at_ukp2394.uk.oracle.com>#1/1
Date: 1996/12/05
Message-ID: <01bbe209$893426a0$4092038a_at_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>...Received on Thu Dec 05 1996 - 00:00:00 CET
> 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
>