Re: adding 1 second to Date(time) in PL/SQL

Calendar arithmetic treats: 1.0 as 1 day, 1/24 as 1 hour, (1/24)/60 as 1 minute, 1/24/60/60 as 1 second. So, just and 1 second to the SYSDATE and you'll get the right date/time:

        select sysdate, sysdate+((1/24)/60)/60 from dual

Sergei

Kevin Gillins wrote:
>
> I would convert the date to a number add 1 then convert it back. The
> functions to be used are
>
> to_number(to_char(sysdate,SSSSS))+1
>
>
> <daud11_at_hotmail.com> wrote in message
> news:7sk2ba$s2l$1_at_nnrp1.deja.com...
> Hi
>
> How can I add 1 second to a Date(time) item using PL/SQL. I
> am using
> Forms ver5.
>
> Thanks
> Daud11
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Sun Sep 26 1999 - 17:56:32 CEST