Loading...
Return the day of the year. This function returns a number from 1 to 366 indicating the day's position within the year.
DAYOFYEAR(date)
Returns the day of the year for date, in the range 1 to 366.
This page is licensed: GPLv2, originally from
SELECT DAYOFYEAR('2018-02-16'); +-------------------------+ | DAYOFYEAR('2018-02-16') | +-------------------------+ | 47 | +-------------------------+