working with hours / sum of hours
Posted: Sat Jun 09, 2012 11:23 am
I was wondering if anybody have any good ideas to working with hours/sum of hours ?
I'm in need of "saving" start point and end point, getting the total of hours between the start and end point (typicaly a workday or less) - i would need this data to be saved and handeled from an MySQL db.
Is the best thing to save timestamps, and work with them, or to save date in one field and start and end time in the other fields ?
I'm in need of "saving" start point and end point, getting the total of hours between the start and end point (typicaly a workday or less) - i would need this data to be saved and handeled from an MySQL db.
Is the best thing to save timestamps, and work with them, or to save date in one field and start and end time in the other fields ?