Mega Code Archive

 

Categories / MSSQL Tutorial / Date Functions

 

Select YEAR(2002-09-30)

4>  select YEAR('2002-09-30') 5> GO -----------        2002 (1 rows affected)