how to select only year from date in sql code example Example: sql get year from datetime field SELECT YEAR(DateTimeField) FROM MyTable