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 query to find correct time diffrence

sql query to find correct time diffrence

From: Jack <amitkr.3_at_gmail.com>
Date: 26 Dec 2005 05:46:21 -0800
Message-ID: <1135604781.568370.118450@z14g2000cwz.googlegroups.com> 





Hi,



I have a table with 2 columns(varchar)  end_time & start_time.
I have to write a query to find the correct diffrence of end_time &
start_time



eg.


start_time   end_time


0830           1705



the query should return ... 0835



Thanks
Received on Mon Dec 26 2005 - 07:46:21 CST












Original text of this message













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