Re: Adding seconds to a date

From: GP <g_palgrave_at_yahoo.com>
Date: 2 Jul 2002 17:55:22 -0700
Message-ID: <680a4735.0207021655.6ff027de_at_posting.google.com>


"Pierre Herman" <pierre.hermanNOSPAM_at_itn.skynet.be> wrote in message news:<3d21c067$0$8135$ba620e4c_at_news.skynet.be>...
> Hello,
>
> My question is pretty simple but anyway...
> I would like to add a number of seconds to a date.
> (oracle 8.1.7.4)
>
> Thanks for answering
>
> ________________________________________________
> [Don't forget to remove the NOSPAM from my e-mail address]

Pierre,

Many ways, but here is one:

To add a minute +1/1440, add a second + 1/86400 Don't have an 8.1.7 system handy, but this works on 8.1.6.3 -

select sysdate, sysdate +1/1440, sysdate + 1/86400 from dual;

SYSDATE SYSDATE+1/1440 SYSDATE+1/86400

-------------------- -------------------- --------------------
03-Jul-2002 08:32:12 03-Jul-2002 08:33:12 03-Jul-2002 08:32:13

Regards.... Received on Wed Jul 03 2002 - 02:55:22 CEST

Original text of this message