Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> difference between 2 dates ?
here is one table who records all the changes of object status
exemple
OBJ status date
A ON 01/01/02 8:00:00 B ON 01/01/02 8:00:00 C ON 01/01/02 10:00:00 A OFF 01/01/02 11:00:00 A ON 01/01/02 12:00:00 B OFF 01/01/02 12:00:00 D ON 01/01/02 13:00:00 A OFF 02/01/02 8:00:00
how can i do by a select query for calculate for each object the total time between ON and OFF Received on Wed Feb 13 2002 - 10:28:13 CST