Re: Adding time to existing Date field

date_field := date_field + (80/(24 * 60 * 60)) It's that easy.

Hth,

Sybrand Bakker, Oracle DBA

premjit <premjit_at_hq.idt.net> wrote in message news:7opujg$goi_at_nnrp3.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 Tue Aug 10 1999 - 14:50:59 CDT