Re: Adding seconds to a date

From: Anurag Varma <avdbi_at_hotmail.com>
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

Original text of this message