Re: How to sum minutes to date

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Thu, 1 Apr 2004 12:44:15 +0100
Message-ID: <406c008f$0$6552$ed9e5944@reading.news.pipex.net>

"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

well if you do normal math and add 1 to a date you add 24 hours to it and get the day afterwards. There are usually 1440 minutes in a day so 20 minutes are 20/1440 of a day.

-- 
Niall Litchfield
Oracle DBA
Audit Commission UK

Received on Thu Apr 01 2004 - 05:44:15 CST