add date to time

From: sgupta <sugandha_g_at_yahoo.com>
Date: 16 Oct 2001 13:57:08 -0700
Message-ID: <62deede6.0110161257.77056370_at_posting.google.com>



Hi

[Quoted] I have a field like this :

[Quoted] 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 Tue Oct 16 2001 - 22:57:08 CEST

Original text of this message