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') 124year;
+-----------------------------------+
|                                 8 |
+-----------------------------------+
##keyword
WEEKOFYEAR