Skip to main content
Skip to main content

WEEKOFYEAR

weekofyear

Description

Syntax

INT WEEKOFYEAR (DATETIME DATE)

Get the Weeks of the Year

The parameter is Date or Datetime type

example

mysql> select weekofyear('2008-02-20 00:00:00');
+-----------------------------------+
| weekofyear('2008-02-20 00:00:00') |
+-----------------------------------+
| 8 |
+-----------------------------------+

keywords

WEEKOFYEAR