Xref: alice comp.databases.oracle.tools:32487
Path: alice!news-feed.fnsi.net!news.idt.net!attmtf!ip.att.net!mercury.cts.com!usc!newshub.csu.net!nntp.csufresno.edu!stevec
Newsgroups: comp.databases.oracle.tools
Subject: Re: adding 1 second to Date(time) in PL/SQL
References: <7sk2ba$s2l$1@nnrp1.deja.com>
Organization: California State University, Fresno
From: stevec@zimmer.csufresno.edu (Steve Cosner)
Lines: 11
Message-ID: <HfjH3.42$dB1.4374@nntp.csufresno.edu>
Date: Sun, 26 Sep 1999 06:42:47 GMT
X-Complaints-To: abuse@csufresno.edu
X-Trace: nntp.csufresno.edu 938328167 129.8.52.99 (Sat, 25 Sep 1999 23:42:47 PDT)
NNTP-Posting-Date: Sat, 25 Sep 1999 23:42:47 PDT

In article <7sk2ba$s2l$1@nnrp1.deja.com>,  <daud11@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