Comments
-
Wow…thank you for putting that amount of time into this. This is extremely helpful!
-
It doesn't appear that SEC_TO_TIME is going to work for what I am attempting to do. As per the documentation, it is limited to 24 hours, and when a value is greater than 24 hours, it will overflow and loop back to 0 hours. What I am attempting to accomplish is that if Employee A's logged in time was 6:43:15, 5:15:45,…
-
To be clear, I'm not dealing with a date time field but rather fields which contain a duration of specific events. For example, the total amout a user may have been logged in in hh:mm:ss for a given date. That said, I think that the SEC_TO_TIME function may be what I am looking for. I will try this and confirm whether or…