How to add seconds to a date field?

From: <anooshak_at_my-deja.com>
Date: Fri, 02 Feb 2001 20:14:28 GMT
Message-ID: <95f4er$iru$1@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 Fri Feb 02 2001 - 14:14:28 CST

This message: [ Message body ]
Next message: Mark Wagoner: "Re: How to add seconds to a date field?"
Previous message: Brian Peasland: "Re: Oracle Password Case Senstivity."
Next in thread: Mark Wagoner: "Re: How to add seconds to a date field?"
Reply: Mark Wagoner: "Re: How to add seconds to a date field?"
Reply: Sybrand Bakker: "Re: How to add seconds to a date field?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US