Subject | Time Elapsed inside Stored Procedure? |
---|---|
Author | dr_bentonquest |
Post date | 2005-01-25T21:02:26Z |
Hi there,
I have this four variables: date1 and date2 are DATE, time1 and time2
are VARCHAR(5) and contain a time value, which I know is always
between '00:00' and '24:59'.
I am looking for ideas on how to compute the time elapsed (in hours)
between the two sets of variables.
Thanks for any hints,
-Benton
I have this four variables: date1 and date2 are DATE, time1 and time2
are VARCHAR(5) and contain a time value, which I know is always
between '00:00' and '24:59'.
I am looking for ideas on how to compute the time elapsed (in hours)
between the two sets of variables.
Thanks for any hints,
-Benton