Re: adding 1 second to Date(time) in PL/SQL
From: Steve Cosner <stevec_at_zimmer.csufresno.edu>
Date: Sun, 26 Sep 1999 06:42:47 GMT
Message-ID: <HfjH3.42$dB1.4374_at_nntp.csufresno.edu>
Date: Sun, 26 Sep 1999 06:42:47 GMT
Message-ID: <HfjH3.42$dB1.4374_at_nntp.csufresno.edu>
In article <7sk2ba$s2l$1_at_nnrp1.deja.com>, <daud11_at_hotmail.com> wrote:
>How can I add 1 second to a Date(time) item using PL/SQL. I am using
>Forms ver5.
my_date := my_date + 1/86400;
or my_date := my_date + .000011574;
(86400 is the number of seconds in one day)
Steve Cosner Received on Sun Sep 26 1999 - 08:42:47 CEST