datetime - 如何从mysql中的日期和时间中减去小时数？

Question

如何在mysql中从日期和时间中减去小时数？

2010-12-04 17:07:14 and 2010-05-30 17:07:19

Answer 1

我假设您的意思是在减去两个日期时需要小时数。如果是这样的话，我在这里找到了以下内容:http://www.dbforums.com/mysql/1637603-datediff-hours.html

You can convert both times to seconds using unix_timestamp. Then subtract one from other to get number of seconds between both times. Then divide by 3600 to get the number of hours

 select ( unix_timestamp( "2010-12-04 17:07:14" ) - 
     unix_timestamp("2010-05-30 17:07:19" ) ) / 3600

*注意:这仅适用于 1970 年之后的日期