WEEKS_DIFF

描述

用于计算两个日期或时间值之间相差的完整周数（以 7 天为单位）。

语法

WEEKS_DIFF(<end_date>, <start_date>)

必选参数

参数名称	数据类型	描述
`end_date`	`DATE`, `DATETIME`	较晚的日期或者日期时间
`start_date`	`DATE`, `DATETIME`	较早的日期或者日期时间

举例

2020-12-25 与 2020-10-25 相差多少周

select weeks_diff('2020-12-25','2020-10-25');

+----------------------------------------------------------+
| weeks_diff('2020-12-25 00:00:00', '2020-10-25 00:00:00') |
+----------------------------------------------------------+
|                                                        8 |
+----------------------------------------------------------+

2020-12-25 10:10:02 与 2020-10-25 12:10:02 相差多少周

select weeks_diff('2020-12-25 10:10:02','2020-10-25 12:10:02');

+--------------------------------------------------------------------------------------------------------+
| weeks_diff(cast('2020-12-25 10:10:02' as DATETIMEV2(0)), cast('2020-10-25 12:10:02' as DATETIMEV2(0))) |
+--------------------------------------------------------------------------------------------------------+
|                                                                                                      8 |
+--------------------------------------------------------------------------------------------------------+

2020-12-25 10:10:02 与 2020-10-25 相差多少周

select weeks_diff('2020-12-25 10:10:02','2020-10-25');

+----------------------------------------------------------------------------------------+
| weeks_diff(cast('2020-12-25 10:10:02' as DATETIMEV2(0)), cast('2020-10-25' as DATEV2)) |
+----------------------------------------------------------------------------------------+
|                                                                                      8 |
+----------------------------------------------------------------------------------------+

WEEKS_ADD WEEKS_SUB