Re: How to add seconds to a DATE ?

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: 1998/01/15
Message-ID: <34d54b32.226916428@inet16>#1/1

On 15 Jan 1998 16:00:18 GMT, "Penalva Jean-Christophe" <jean-christophe.penalva_at_cnusc.fr> wrote:

> Hello,
>
> i have a colum of DATE type. I'd like to add to this column a value in
>seconds for example.
>
> I know it's a so silly question, but perhaps i'm silly ??!! :-)
>
> PLEASE HELP ME.
>
>mailto:jean-christophe.penalva_at_cnusc.fr

date arithmetic is done by days. so to add

a day:    sysdate+1
an hour:  sysdate+1/24
a minute: sysdate+1/24/60
a second: sysdate+1/24/60/60

multiply to add days, hours, minutes, seconds and so on....  

Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Bethesda MD  

http://govt.us.oracle.com/ -- downloadable utilities  

---

Opinions are mine and do not necessarily reflect those of Oracle Corporation  

Anti-Anti Spam Msg: if you want an answer emailed to you, you have to make it easy to get email to you. Any bounced email will be treated the same way i treat SPAM-- I delete it. Received on Thu Jan 15 1998 - 00:00:00 CST