2
Good afternoon,
Could someone help me with this? I am in need of storing values longer than 838:59:59 in the TIME field in Mysql. Is there any alternative for the TIME type to be able to store value greater than 838:59:59?
I appreciate anyone who can help me.
Do you need to record a elapsed time field? Why not use integer/big int converted to seconds?
– Murillo Goulart
Vc says convert the format, for example 1445:45:00 to integer?
– Jorgito da Silva Paiva
I will expect very good answers, because date/time is a weakness of mine.
– Not The Real Hemingway
This: record 00 + (45 * 60) + (1445 * 60 * 60) = 5202000 seconds
– Murillo Goulart
Ah yes, thanks for the tip, I’ll try to do something like this, thank you!
– Jorgito da Silva Paiva