get the year from date in sql server code example Example: get current year sql select year(getdate())