Mega Code Archive

 

Categories / MSSQL Tutorial / Date Functions

 

Select DATEPART(dayofyear, 2002-09-30 11

3>  select DATEPART(dayofyear, '2002-09-30 11:35:00') 4> GO -----------         273 (1 rows affected) 1>