Re: Adding time to Date field

Try this:

select

   sysdate,
   to_date(to_char(sysdate, 'mmddyyyy')||to_char(to_number(to_char(sysdate, 'SSSSS'))+(60*80)), 'mmddyyyysssss')
from dual

Replace sysdate with the field name you want.

premjit <premjit_at_hq.idt.net> wrote in message news:7os961$c7n_at_nnrp2.farm.idt.net...
> 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
>
>
>
Received on Wed Aug 11 1999 - 12:26:24 CDT