WEEKS_DIFF

描述

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

语法

WEEKS_DIFF(<end_date>, <start_date>)

必选参数

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

举例

1. 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 |
   +----------------------------------------------------------+

2. 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 |
   +--------------------------------------------------------------------------------------------------------+

3. 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 |
   +----------------------------------------------------------------------------------------+