Store time in TIME type field greater than 838:59:59 in Mysql

Question

Store time in TIME type field greater than 838:59:59 in Mysql

Asked 7 years, 3 months ago

Viewed 74 times

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.

1

Do you need to record a elapsed time field? Why not use integer/big int converted to seconds?

– Murillo Goulart

2017/03/16 at 17:45
Vc says convert the format, for example 1445:45:00 to integer?

– Jorgito da Silva Paiva

2017/03/16 at 17:50
I will expect very good answers, because date/time is a weakness of mine.

– Not The Real Hemingway

2017/03/16 at 17:51
1

This: record 00 + (45 * 60) + (1445 * 60 * 60) = 5202000 seconds

– Murillo Goulart

2017/03/16 at 17:53
Ah yes, thanks for the tip, I’ll try to do something like this, thank you!

– Jorgito da Silva Paiva

2017/03/16 at 18:03

No answers

Browser other questions tagged mysql time

You are not signed in. Login or sign up in order to post.