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 -> SQL question

SQL question

From: usmrall <srallapally_at_netscape.net>
Date: Sat, 27 Mar 1999 17:40:38 GMT
Message-ID: <7dj56l$98j$1@nnrp1.dejanews.com>


Hi all,
I have a table or events which looks like this

Event# Event EventDate      EventText
100     PKD   199812010745    Picked up cargo
100     BKD   199812152100    Booked Cargo
100     OBF   199812160600    On board flight
100     DOT   199812171300    Delivered to Trucker

I am trying to get a report which lists the date difference between the dates for PKD and BKD, PKD and OBF, PKD and DOT events like Event (PKD - BKD) (PKD - OBF) (PKD - DOT)



100 ??? ??? ???

I was wondering if the more SQL-enlightened of you could help me out. Also, how can we handle time subtraction in Oracle ? By using trunc, I can get date differences, but I need time differences too. tia
sanjay

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Sat Mar 27 1999 - 11:40:38 CST

Original text of this message

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