WEEK()

This page is part of MariaDB's MariaDB Documentation.

The parent of this page is: Functions

Topics on this page:

Overview
EXAMPLES
CHANGE HISTORY
EXTERNAL REFERENCES

Overview

Returns the week number for date. The two-argument form allows you to specify whether the week starts on Sunday or Monday and whether the return value should be in the range from 0 to 53 or from 1 to 53. If the mode argument is omitted, the value of the default_week_format system variable is used.

See also: Functions in 10.6 ES, in 10.5 ES, and in 10.4 ES

EXAMPLES

SELECT WEEK('2020-02-01');

+--------------------+
| WEEK('2020-02-01') |
+--------------------+
|                  4 |
+--------------------+

SELECT WEEK('2020-02-29',0);

+----------------------+
| WEEK('2020-02-29',0) |
+----------------------+
|                    8 |
+----------------------+

SELECT WEEK('2020-02-01',1);

+----------------------+
| WEEK('2020-02-01',1) |
+----------------------+
|                    5 |
+----------------------+

SELECT WEEK('2020-02-29',7);

+----------------------+
| WEEK('2020-02-29',7) |
+----------------------+
|                    8 |
+----------------------+

CHANGE HISTORY

Release Series	History
10.6 Enterprise	Present starting in MariaDB Enterprise Server 10.6.4-1.
10.6 Community	Present starting in MariaDB Community Server 10.6.0.
10.5 Enterprise	Present starting in MariaDB Enterprise Server 10.5.3-1.
10.5 Community	Present starting in MariaDB Community Server 10.5.0.
10.4 Enterprise	Present starting in MariaDB Enterprise Server 10.4.6-1.
10.4 Community	Present starting in MariaDB Community Server 10.4.0.
10.3 Enterprise	Present starting in MariaDB Enterprise Server 10.3.16-1.
10.3 Community	Present starting in MariaDB Community Server 10.3.0.
10.2 Enterprise	Present starting in MariaDB Enterprise Server 10.2.25-1.
10.2 Community	Present starting in MariaDB Community Server 10.2.0.

Release Series	History
10.6 Enterprise	Present starting in MariaDB Enterprise Server 10.6.4-1.
10.5 Enterprise	Present starting in MariaDB Enterprise Server 10.5.3-1.
10.4 Enterprise	Present starting in MariaDB Enterprise Server 10.4.6-1.

EXTERNAL REFERENCES

Additional information on this topic may be found in the MariaDB Public Knowledge Base.