Re: [CHALLANGE] Add seconds to a date

[Quoted] try somrthing like :

select to_char(sysdate,'MI:SS'), to_char(sysdate+100/(24*60*60),'MI:SS') from dual;

hth.

Yann

panjas51 a écrit dans le message
<3c1b889f.0202250828.772510aa_at_posting.google.com>...
>I tried to make a PLSQL (oracle) function in order to add some seconds
>to a specified date:
>
>Let's take a exemple:
>New_date=sec2date(#2002-02-02#, 100),
>this should add 100 seconds to the entered date:
>this should then return "2002-02-02 00:01:40".
>
>Attention to the lead year.
>
>If any one wants to take this challage or propose some quick wins
>idees
Received on Mon Feb 25 2002 - 17:44:03 CET