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

Re: sql query to find correct time diffrence

From: <fitzjarrell_at_cox.net>
Date: 26 Dec 2005 05:59:41 -0800
Message-ID: <1135605581.465600.280570@g44g2000cwa.googlegroups.com>


Comments embedded.
Jack wrote:
> 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

Then why are you asking US to write it?

>
> eg.
> start_time end_time
> 0830 1705
>
> the query should return ... 0835
>

Last I checked 17 hours and 5 minutes equals 16 hours and 65 minutes ...
and I leave the rest up to you.

> Thanks

You're more than welcome, and I hope your homework gets completed on schedule.

David Fitzjarrell Received on Mon Dec 26 2005 - 07:59:41 CST

Original text of this message

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