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 -> Adding to Time in Date fields

Adding to Time in Date fields

From: Marc <marc_at_popmail.med.nyu.edu>
Date: 1996/12/03
Message-ID: <32A440DF.3F1@popmail.med.nyu.edu>#1/1

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 Tue Dec 03 1996 - 00:00:00 CST

Original text of this message

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