Re: add date to time
From: Samuel Leung <kalawuf_at_ctimail3.com>
Date: Wed, 17 Oct 2001 16:46:57 +0800
Message-ID: <9qjgcp$f38$1_at_news.ctimail.com>
Date: Wed, 17 Oct 2001 16:46:57 +0800
Message-ID: <9qjgcp$f38$1_at_news.ctimail.com>
Hi,
1 day = 86400 seconds
<date_field> + 1/86400 will add one second to the date field
5h:02m:31s = 18151 seconds
Therefore <date_field> + (1/86400 * 18151) will add 5h02m31s to the date field
Samuel
kalawuf_at_hotmail.com
"sgupta" <sugandha_g_at_yahoo.com> wrote in message
news:62deede6.0110161257.77056370_at_posting.google.com...
> Hi
>
> I have a field like this :
>
> 10/16/2001 10:40:56 AM
>
> I want it to adjust it by adding 5h:02m:31s to compensate for diff
> times on 2 diff machines.
> How do i do it. I am new to oracle and no clue how to
>
> -sg
Received on Wed Oct 17 2001 - 10:46:57 CEST