KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I'm Trying to get the timediff from my table and convert it to hours (it's for an hourly billed service) SELECT TIME_TO_SEC(TIMEDIFF(endDate,startDate))/3600 FROM tasks > where endDate and startDate are in datetime format is there another way (more efficient) to do this task? Thanks !
Tags (comma-separated)
Save Edits
Cancel