SQL Subtracting Dates - Unit of Measure for Result?

[Stephen Weiler]

I'm subtracting one date from another, hopefully to determine the elapsed time between the two dates. The query completes, but I cannot determine the unit of measure for the result. I'm hoping to know the number of hours (rounded up) between these dates.

 

select 
    h_datelogged,
    h_dateresolved,
    h_dateresolved-h_datelogged Difference
from h_itsm_requests
limit 2

Does anyone know the default unit of measure?

 

Thanks!

[Victor]

@Stephen Weiler good question. I would have said seconds, but that number is not the number of seconds between those dates... honestly I have no idea what the query does with that difference...

However, if you are after the number of hours between the two, use this: TIMESTAMPDIFF(HOUR, h_datelogged, h_dateresolved) AS difference

[Stephen Weiler]

Thank you! The TIMESTAMPDIFF() function is what I needed. I'm used to native SQL and was trying DATEDIFF() with no luck. I appreciate the help!