title: DayOfYear function in T-SQL / SQL Server 2000
body: <p>2 FEB is the 33rd day of the year, for example. </p>
  
  <p>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?</p>