W3School TIY Editor

SELECT DatePart("yyyy", #09/05/2017#);