Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> SQL question
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)
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