将时间跨度存储在MySQL数据库中的最佳方法?

本文介绍了将时间跨度存储在MySQL数据库中的最佳方法?的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

我想在mysql数据库中存储某些内容的时间，例如某时间所花费的时间，例如2小时，5分钟，10秒.精度低至秒是首选，但不是必需的.最好的方法是什么?

I'd like to store an amount of time for something in a mysql database,for the length of time something took, such as 2 hours, 5 minutes, 10 seconds. accuracy down to the second is preferred, but not required. What's the best way to go about doing this?

推荐答案

MySQL TIME 类型可以存储从'-838:59:59'到'838:59:59'的时间跨度-如果在您要求的范围内，那么让MySQL在本地显示这些跨度会很有用HH:MM:SS表单，然后使用该表单.

A MySQL TIME type can store time spans from '-838:59:59' to '838:59:59' - if that's within your required range, and it would be useful to have MySQL natively present these spans in HH:MM:SS form, then use that.

否则，我将使用整数类型来表示秒数.

Otherwise, I'd just go with an integer type to represent the number of seconds.