DAYOFYEAR

Return the day of the year. This function returns a number from 1 to 366 indicating the day's position within the year.

Syntax

DAYOFYEAR(date)

Description

Returns the day of the year for date, in the range 1 to 366.

Examples

SELECT DAYOFYEAR('2018-02-16');
+-------------------------+
| DAYOFYEAR('2018-02-16') |
+-------------------------+
|                      47 |
+-------------------------+

_{This page is licensed: GPLv2, originally from fill_help_tables.sql}