Javatpoint Logo
Javatpoint Logo

MySQL DAYOFYEAR() Function

The dayofyear() is a MySQL date/time function. It is used to get the number of day of the year.

Syntax

Parameter:

Date: date value for getting a day of the year.

Returns

This function returns day of the year for a date value.

Example 1

Output:


MySQL DAYOFYEAR() Function

Example 2

Output:


MySQL DAYOFYEAR() Function
Next TopicMySQL date/time




Help Others, Please Share

facebook twitter google plus pinterest

Learn Latest Tutorials


Preparation


Trending Technologies


B.Tech / MCA