how to take the year using date stored in DataBase:

in Sql query ?? ????

eg date stored as

2010-04-29 15:53:09.577

how to get the year in stored procedure to check whether the year i pass and the year stored in database are same