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>
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