How to get Day of Year from date in SQL Server

Method #1: Using DATEPART Function

SELECT GETDATE() 'Today', DATEPART(dayofyear,GETDATE()) [Day_of_Year]
SELECT GETDATE() 'Today', DATEPART(dy,GETDATE()) [Day_of_Year]
SELECT GETDATE() 'Today', DATEPART(y,GETDATE()) [Day_of_Year

Method #2: Using DATENAME Function

SELECT GETDATE() 'Today', DATENAME(dayofyear,GETDATE()) [Day_of_Year]
SELECT GETDATE() 'Today', DATENAME(dy,GETDATE()) [Day_of_Year]
SELECT GETDATE() 'Today', DATENAME(y,GETDATE()) [Day_of_Year]