Save time duration of greater that 24 hours

Question

I have a Database in 4th Dimension. It stores its time values in number format (seconds).

Now I have a Time duration of 29:30:00 ( 29 hours: 30 min : 00 Sec )

But this conflicts with the TIME rules of mySQL ( cant be > 23:59:59 )

I tried to convert this to number and save it, but I suspect it MySQL sees that it is a Time field and a number is not valid.

I was thinking about a format like DD:HH:MM:SS but im not sure if that is allowed.

Answer 1

There should be no problem storing time values greater than 24 hours in either 4D or mySQL.

4D:

A Time field, variable or expression can be in the range of 00:00:00 to 596,000:00:00

mySQL:

TIME values may range from '-838:59:59' to '838:59:59'.