Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Question on subtracting timestamps
I am trying to subtract the arrival date/time of an employee from the date/time a work order is closed in order to obtain the length of time the work took to complete. Can someone help with the correct format for this?
Example:
arrival_time = '31-JAN-2000 23:11:09'
wo_closed_time = '1-FEB-2000 01:29:00'
repair_time = ?
Thanks so much in advance for your help. It is greatly appreciated! Received on Mon Apr 23 2001 - 11:32:18 CDT