Mega Code Archive

 

Categories / MSSQL / Date Timezone

 

Select YEAR(2002-09-30)

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