Calculate Time 1

[heydyrtt]

Have a table with a starttime and endtime, need a query that will tell me how much time was spent using starttime and the endtime. If the start time is 11:00 am and endtime is 1:00 pm I need the query to display that it took 2 hours.


Thanks



Heydyrtt

 

[towerbase]

What data types are starttime and endtime?

What queries have you tried so far and what where the results?

Andrew
Hampshire, UK

 

[r937]

if the datatypes are times,

select sec_to_time(
       time_to_sec(endtime)
      -time_to_sec(starttime)
                  ) as elapsed_time
  from yourtable

rudy

http://r937.com/

SQL Consulting

 

[heydyrtt]

Thanks r937, that got it.

Heydyrtt