Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Converting between Ingres and Oracle: Calculations with dates.
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