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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Converting between Ingres and Oracle: Calculations with dates.

Re: Converting between Ingres and Oracle: Calculations with dates.

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Thu, 20 Jan 2000 11:40:15 -0500
Message-ID: <9jee8ssiq767cefqofnn8e17kgdq0uln91@4ax.com>


A copy of this was sent to "Technical" <technical_at_fma-systems.com> (if that email address didn't require changing) On Thu, 20 Jan 2000 15:20:14 -0000, you wrote:

>Dear All.
>
>Tanks for those who replied to my last message regarding Ingres Oracle
>converting. I have another problem.
>
>Under Ingres when using dates you can perform normal calculations on dates
>as normal e.g.
>
>Time_diff = (Time_out - Time_In) (All of these are of type date).
>
>My question is simply this: How can this be done under Oracle.
>
>Tanks in advance.
>
>Lloyd Graney.
>

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

--
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 Thu Jan 20 2000 - 10:40:15 CST

Original text of this message

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