SQL Function Reference

DAYOFYEAR

Returns the day of the year (1-366) for a given date.

MySQL

DAYOFYEAR(date)

date

The date or datetime value.

Examples

MySQL

SELECT DAYOFYEAR(date)
FROM Payments;

MySQL

SELECT member_name,
	DAYOFYEAR(birthday)
FROM FamilyMembers;