SQL or PL/SQL Help of Just Plain Help!! (newbie)

From: Boscia <rwboscia_at_worldnet.att.net>
Date: Wed, 19 Jan 2000 22:06:42 -0700
Message-ID: <B4ABE5F2.A7D%rwboscia_at_worldnet.att.net>

[Quoted] [Quoted] I am running Oracle Reports and attempting to write SQL to pull data from tables...

[Quoted] I have fields of data that are DATE (mm-dd-yyy hh:mm).     

Example:     db1.ticketno     db1.dateentered        db1.daterevised
                 32            01-02-2000 00:00        01-05-2000 11:59

[Quoted] [Quoted] How can I subtract one date from another and come up with a cycle time [Quoted] report that would show the amount of time in days, hours and minutes that it [Quoted] took from the time that ticket was entered until it was revised?  

[Quoted] [Quoted] (If PL/SQL is needed, please go easy on me, since I am not very familiar [Quoted] with it and no one in my office knows it either!!)

Thanks in advance...
Robin Received on Thu Jan 20 2000 - 06:06:42 CET