Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Adding to Time in Date fields
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 CST
> 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
>