select distinct(DatePart(year, pressDate)) as pressDateYear from ts_press_release order by pressDateYear desc

Err Number: -2147217913

Err Source: Microsoft OLE DB Provider for ODBC Drivers

Err Description: [Microsoft][ODBC SQL Server Driver][SQL Server]Syntax error converting datetime from character string.