VeloDB Cloud
SQL Reference
SQL Functions
Scalar Functions
Date Time Functions
WEEKOFYEAR

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