WEEKS_DIFF
Description
Calculates the number of complete weeks (in 7-day units) between two date or time values.
Syntax
WEEKS_DIFF(<end_date>, <start_date>)
Required parameters
Parameter Name | Data Type | Description |
---|---|---|
end_date | DATE , DATETIME | Later date or date-time |
start_date | DATE , DATETIME | Earlier date or date-time |
Example
-
How many weeks are there between
2020-12-25
and2020-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 |
+----------------------------------------------------------+ -
How many weeks are there between
2020-12-25 10:10:02
and2020-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 |
+--------------------------------------------------------------------------------------------------------+ -
How many weeks are there between
2020-12-25 10:10:02
and2020-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 |
+----------------------------------------------------------------------------------------+