DayOfYear function in T-SQL / SQL Server 2000

Question

2 FEB is the 33rd day of the year, for example.

Is there a built-in T-SQL function that returns the day-of-year (in SQL Server 2000)? Or do you have to roll your own using casts to get the first day of the year for the supplied date, and then do a DateDiff?

score 39 · Accepted Answer · answered Sep 21 '12 at 18:17

39

SELECT datepart(dayofyear, getdate())

answered Sep 21 '12 at 18:17

LittleBobbyTables - Au Revoir

32,008
25
109
114

DayOfYear function in T-SQL / SQL Server 2000

1 Answers1