C-Sharp | Java | Python | Swift | GO | WPF | Ruby | Scala | F# | JavaScript | SQL | PHP | Angular | HTML
MySQL DAYOFYEAR() FunctionThe dayofyear() is a MySQL date/time function. It is used to get the number of day of the year. Syntaxselect dayofyear(date); Parameter:Date: date value for getting a day of the year. ReturnsThis function returns day of the year for a date value. Example 1Select dayofyear('2018-01-1'); Output: Example 2Select dayofyear('2018-09-26'); Output:
Next TopicMySQL date/time
|