SQL DAYOFYEAR() Function

SQL DAYOFYEAR() Syntax

The below syntax is used to extract day of the year from given a input date value.

For SQL SERVER / MY SQL

SELECT DAYOFYEAR('valid_date_value');

For MS Access

SELECT DATEPART('y', 'valid_date_value');

SQL DAYOFYEAR() Example - Using Expression Or Formula

The following SQL SELECT statement will extract day of the year from a given input date value. We use now() function to get the input date value.

For SQL SERVER / MY SQL

SELECT 
NOW() AS 'Current Date and Time', 
DAYOFYEAR(NOW()) AS 'Day Of The Year';

For MS Access

SELECT 
NOW() AS 'Current Date and Time', 
DATEPART('y', NOW()) AS 'Day Of The Year';

The result of above query is:

Sample Database Table - BookOrder

SQL DAYOFYEAR() Example - With Table Column

The following SQL SELECT statement display the column "OrderDate", from the "BookOrder" table. The DAYOFYEAR() function will extract day of the year from the column "OrderDate" and we will stored that value to a new column called "Day Of The Year".

For SQL SERVER / MY SQL

SELECT OrderDate, 
DAYOFYEAR(OrderDate) As 'Day Of The Year'
FROM BookOrder;

For MS Access

SELECT OrderDate, 
DATEPART('y', OrderDate) AS 'Day Of The Year'
FROM BookOrder;

The result of above query is: