From: anooshak@my-deja.com
Newsgroups: comp.databases.oracle.misc
Subject: How to add seconds to a date field?
Date: Fri, 02 Feb 2001 20:14:28 GMT
Organization: Deja.com
Lines: 9
Message-ID: <95f4er$iru$1@nnrp1.deja.com>
NNTP-Posting-Host: 171.161.160.10
X-Article-Creation-Date: Fri Feb 02 20:14:28 2001 GMT
X-Http-User-Agent: Mozilla/4.0 (compatible; MSIE 5.0; Windows NT; DigExt)
X-Http-Proxy: HTTP/1.1 jvfcache1[0A580D14] (Traffic-Server/3.5.4 [uNcMs f p eN:t cCMi p s ]), HTTP/1.1 spxyric1[ABB6AF9C] (Traffic-Server/3.5.3 [uNcMs f p eN:t cCMi p s ]), 1.0 x64.deja.com:80 (Squid/1.1.22) for client 171.161.160.10
X-MyDeja-Info: XMYDJUIDanooshak


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/