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