Re: How to add seconds to a date field?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sat, 3 Feb 2001 09:53:30 +0100
Message-ID: <t7nhsgltdsn701@beta-news.demon.nl>

To add seconds add them as a fraction of a day. Milliseconds is not possible.

Hth,

Sybrand Bakker, Oracle DBA

<anooshak_at_my-deja.com> wrote in message news:95f4er$iru$1_at_nnrp1.deja.com...
> Inside my stored procedure I like to get a column of type date and add
> 20 seconds to it. Any suggestions?
> Also could I get miliseconds in a date data type?
>
> Anoosh
>
>
> Sent via Deja.com
> http://www.deja.com/
Received on Sat Feb 03 2001 - 02:53:30 CST