5 ms·
The MySQL documentation suggests using it to store a time interval: "The hours part may be so large because the TIME type can be used not only to represent a t
by robsws 6y ago
The MySQL documentation suggests using it to store a time interval:
"The hours part may be so large because the TIME type can be used not only to represent a time of day (which must be less than 24 hours), but also elapsed time or a time interval between two events (which may be much greater than 24 hours, or even negative)." [1]
How is the author's usage incorrect? Sure there's a documented allowed range, but it seems to me that the complaint is about the poor size of the range relative to other SQL technologies.
[1] https://dev.mysql.com/doc/refman/5.7/en/time.html https://dev.mysql.com/doc/refman/5.7/en/time.html
- deleted 6y ago[deleted]
- kazinator 6y agoThe documentation is valuable in the following way: based on almost every aspect of the documentation, the datatype is not something I would use. Those who use it and get burned didn't get the main message.