Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: adding one time field to another

Re: adding one time field to another

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Tue, 7 Aug 2001 23:39:55 +0200
Message-ID: <997220397.23825.0.pluto.d4ee154e@news.demon.nl>

"Seth" <sgelberg_at_optonline.net> wrote in message news:f3159b28.0108071319.4bab0c5a_at_posting.google.com...
> I will have two fields one sysdate and the other say (00:15) for 15
 minutes.
>
> I would like to add this to sysdate how can I do this?

convert 15 minutes to a fraction of a day and you will be capable adding it.

Hth,

Sybrand Bakker, Senior Oracle DBA Received on Tue Aug 07 2001 - 16:39:55 CDT

Original text of this message

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