Re: Adding to Time in Date fields

From: N.Prabhakar <prabhs_at_pacific.net.sg>
Date: 1996/12/04
Message-ID: <582h29$3ln@newton.pacific.net.sg>#1/1

Marc <marc_at_popmail.med.nyu.edu> writes: > 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

Hi there,

You can try the following.

update t1 set
date_column = date_column + ( sysdate + 1/ 1440)

this will increase the time stamp by 1 minute.

Good Luck

N.Prabhakar Received on Wed Dec 04 1996 - 00:00:00 CST