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

From: Kevin Gillins <kevin_gillins_at_compuserve.com>
Date: Sat, 25 Sep 1999 23:42:28 -0400
Message-ID: <7sk4fv$fkj$1_at_ssauraaa-i-1.production.compuserve.com>

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 - 05:42:28 CEST

This message: [ Message body ]
Next message: Dirk Bellemans: "Re: Newbie Question - Setting a report in descending order"
Previous message: daud11_at_hotmail.com: "adding 1 second to Date(time) in PL/SQL"
In reply to: daud11_at_hotmail.com: "adding 1 second to Date(time) in PL/SQL"
Next in thread: Steve Cosner: "Re: adding 1 second to Date(time) in PL/SQL"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message