[KLUG Members] Subtracting Time

[Patrick Mc Govern]

Oops!  It occurred to me that I should be able to pass the date/time values 
to the Oracle database in a sql script and extract the time value from
the return value.  This should be fairly easy.
Pat


-----Original Message-----
From: Patrick McGovern <pmcgover@gfs.com>
To: Members@kalamazoolinux.org <Members@kalamazoolinux.org>
Date: Tuesday, July 02, 2002 5:20 PM
Subject: [KLUG Members] Subtracting Time


>Just curious if any one has a way to find time differences for 24 hour
>formats.  
>An example of the program output data is below:
>
>start_date         start_time        end_date           end_time
>06/30/2002     06:30              06/30/2002       17:07
>
>I want to find the time difference between the start time and the end
>time.  
>I need to subtract the end_time from the start_time.  I don't think the
>dates 
>matter much since the difference is obvious if the start time is
>greater than 
>the end_time and the data does not span more than 24 hours.
>
>Does any one have a Unix shell script that will calculate this time
>difference?
>Pat  
>
>
>_______________________________________________
>Members mailing list
>Members@kalamazoolinux.org
>
>