KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I'll illustrate what I would like to get in the following example: '2010-09-01 03:00:00' - '2010-09-01 00:10:00' Using TIMEDIFF() , we get 2 as a result. This means, it's not considering the 50 minutes left. In this case, what I'd like to get is: 50 (minutes) / 60 = 0.83 period. Therefore, the result should be 2.83 and not 2.
Tags (comma-separated)
Save Edits
Cancel