Re: Adding seconds to a date
Date: Tue, 2 Jul 2002 16:50:57 -0400
Message-ID: <jqoU8.5563$68.161220_at_news4.srv.hcvlny.cv.net>
This is a FAQ. Next time you should go to www.orafaq.com before posting these questions. or do a search on this newsgroup ...
Can you figure it out using the example below: select to_char(sysdate, 'mm/dd/yyyy hh24:mi:ss') now, 2 to_char(sysdate + 30/(24*60*60), 'mm/dd/yyyy hh24:mi:ss') now_plus_30_secs from dual;
NOW NOW_PLUS_30_SECS ------------------- -------------------07/02/2002 16:47:23 07/02/2002 16:47:53
Anurag
"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]
>
>
Received on Tue Jul 02 2002 - 22:50:57 CEST