I have columns in a table defined with a date 'YYYY-MM-DD' (data type: date) and time 'HH-MM-SS "(data: time) must.
Now I would like the entries in / out lines and such are within a defined date. For each line, the overall total of the time are calculated.
I get a multi figure I assume that it is the Unixtimestamp act. How do I reformat now, again a time HH-MM-SS arises. For example, 68:50:00.