WEEKS_ADD
Description
This function is used to add (or subtract) a certain number of weeks from a specified date or time value.
Syntax
WEEKS_ADD(<datetime_or_date_value>, <weeks_value>)
Required parameters
Parameter | Description |
---|---|
<datetime_or_date_value> | DATETIME or DATE type date input value |
<weeks_value> | Integer, indicating the number of weeks to increase or decrease (positive number indicates increase, negative number indicates decrease) |
example
-
Add one week to the time
2020-02-02 02:02:02
select weeks_add("2020-02-02 02:02:02", 1);
+-------------------------------------+ | weeks_add('2020-02-02 02:02:02', 1) | +-------------------------------------+ | 2020-02-09 02:02:02 | +-------------------------------------+
-
Subtract one week from the time
2020-02-02 02:02:02
select weeks_add("2020-02-02 02:02:02", -1);
+-------------------------------------------------------------+ | weeks_add(cast('2020-02-02 02:02:02' as DATETIMEV2(0)), -1) | +-------------------------------------------------------------+ | 2020-01-26 02:02:02 | +-------------------------------------------------------------+
-
Add one week to the date
2020-02-02
select weeks_add("2020-02-02", 1);
+--------------------------------------------+ | weeks_add(cast('2020-02-02' as DATEV2), 1) | +--------------------------------------------+ | 2020-02-09 | +--------------------------------------------+