MySQL中日期之间的月差 [英] The difference in months between dates in MySQL

问题描述

我想计算 2 个日期时间字段之间的月数.

I'm looking to calculate the number of months between 2 date time fields.

有没有比获取 unix 时间戳并除以 2 592 000(秒)并在 MySQL 中四舍五入更好的方法?

Is there a better way than getting the unix timestamp and the dividing by 2 592 000 (seconds) and rounding up whithin MySQL?

推荐答案

DATEDIFF 函数可以为您提供两个日期之间的天数.哪个更准确，因为......你如何定义一个月?(28、29、30 或 31 天?)

The DATEDIFF function can give you the number of days between two dates. Which is more accurate, since... how do you define a month? (28, 29, 30, or 31 days?)

这篇关于MySQL中日期之间的月差的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！