Re: How to sum minutes to date

"Max" <m.daniello_at_rational-services.it> wrote in message news:c4gshi$2j5ia4$1_at_ID-224556.news.uni-berlin.de...
| Hi all,
| I need to sum x minutes to a date. Ex. the value I select is '01/01/2004
| 12:30' and I need to sum '20' minutes so to obtain '01/01/2004 12:50'.
| How could I do? I not find in Oracle 9i a function to sum time.
| Thanks in advanced
|
|

i believe you're asking about date addition, specifically how to add minutes to a date value

oracle date addition (without functions) works with days -- ie, sysdate + 1 is the current date plus 24 hours. to add minutes, just add the correct fraction of a day (no function needed) -- ie sysdate + (1/24/60*20)

;-{ mcs Received on Thu Apr 01 2004 - 05:41:00 CST