Re: Adding time to Date field

From: <rock_cogar_at_my-deja.com>
Date: Wed, 11 Aug 1999 17:56:33 GMT
Message-ID: <7osdga$j5o$1@nnrp1.deja.com>

Maybe you can do it with the following 3 steps ?

use to_char() to convert selected date:time into a string
modify the time portion of the string
use to_date() to convert back to the date:time type

Also, you can adjust the time by even hours with the new_time() function.

Rock Cogar.

In article <7os961$c7n_at_nnrp2.farm.idt.net>, "premjit" <premjit_at_hq.idt.net> wrote:
> Hi,
>
> Can anyone let me know how to add say one hour and 20 minutes to the
> existing date field. The date field is fetched from the field in a
table by
> PL/SQL.
>
> Thanks
>
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Wed Aug 11 1999 - 12:56:33 CDT