MySQL中日期之间的月差

2021-11-20 00:00:00 date mysql datediff date-arithmetic

我想计算 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?)

相关文章