Re: Time Operations

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Tue, 04 Jan 2000 08:33:41 -0500
Message-ID: <ojt37s04gbstjlh0aq7rsfhquolmai6ch7@4ax.com>

A copy of this was sent to "Daniel" <fiudi @@@ hotmail com> (if that email address didn't require changing) On Tue, 4 Jan 2000 13:34:39 +0100, you wrote:

>Hello
>
>I'm trying to do some time calculations like:
>
>select to_date('03:15:00', 'hh:mi:ss') - to_date('03:00:00', 'hh:mi:ss')
>test
>from dual;
>
> TEST
>---------
>.01041667
>
>The problem is to set 'TEST' back to a time (resp. date) format.
>Any suggestions?
>

see http://osi.oracle.com/~tkyte/Misc/DateDiff.html

>Thanks
>Dan
>
>
>

--
See http://osi.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Tue Jan 04 2000 - 07:33:41 CST