Skip to content

Latest commit

 

History

History
86 lines (70 loc) · 2.54 KB

weeks-add.md

File metadata and controls

86 lines (70 loc) · 2.54 KB
title language
WEEKS_ADD
en

Description

This function is used to add (or subtract) a certain number of weeks from a specified date or time value.

Syntax

WEEKS_ADD([<date_value> | <datetime_value>], <weeks_value>)

Required parameters

<weeks_value>

Integer, indicating the number of weeks to increase or decrease (positive number indicates increase, negative number indicates decrease)

Optional parameters

  • <date_value>

    DATE date type input value

  • <datetime_value>

    DATETIME time type input value

example

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

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

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