WEEKS_DIFF
weeks_diff
description
Syntax
INT weeks_diff(DATETIME enddate, DATETIME startdate)
开始时间到结束时间相差几星期
example
mysql> select weeks_diff('2020-12-25','2020-10-25');
+----------------------------------------------------------+
| weeks_diff('2020-12-25 00:00:00', '2020-10-25 00:00:00') |
+----------------------------------------------------------+
| 8 |
+----------------------------------------------------------+
keywords
weeks_diff