Re: Adding time to Date field

Seems like quite a few conversions there. You can add directly to date fields where 1 is one day, 1/24 is one hour, 1/1440 is one minute, 1/86400 is one second... Why not do this instead?

update table set your_date = your_date + 80*(1/1440) where condition

Hope this helps,
-Jeff Guttadauro

On Wed, 11 Aug 1999 13:26:24 -0400, "vr0506" <NoSpam_at_SomeDomain.Com> wrote:

>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 - 13:35:48 CDT