MySQL DAYOFYEAR() Function
Definition and Usage
The DAYOFYEAR() function returns the day of the year for a given date (a number from 1 to 366).
Syntax
DAYOFYEAR(date)
Parameter Values
Parameter | Description |
---|---|
date | Required. The date to return the day of the year from |
Technical Details
Works in: | From MySQL 4.0 |
---|
More Examples
Example
Return the day of the year for the current system date:
SELECT DAYOFYEAR(CURDATE());
Try it Yourself »