Teradata Import Query Error

[JLuebbert]

I am able to run the query below in Teradata without any errors

SELECT 
YEAR(DATE_FIELD) AS DATE_YEAR
,A.FIELD_1
,A.FIELD_2
,B.FIELD_3
,SUM(AMT_1) AS SUM_AMT_1
,SUM(AMT_2) AS SUM_AMT_2
FROM TABLE_1 AS A
LEFT JOIN TABLE_2 AS B ON A.FIELD_1 = B.FIELD_1
GROUP BY YEAR(DATE_FIELD),FIELD_1,FIELD_2,FIELD_3

but when entered into the SQL Statement section of the Teradata database connection window I get the an error that looks like a Teradata error saying: 

DataSource.Error: Teradata: [Teradata Database] [3706] Syntax error: expected something between the 'SELECT' keyword and the 'YEAR' keyword.

I am using Import as the connection type.  Is there a function other than YEAR() that should be used?  What is the true cause of this error as I know the syntax is correct.

[Anonymous · Accepted solution]

@JLuebbert,

Can you try SELECT EXTRACT(YEAR FROM DATE_FIELD)?

[JLuebbert]

Thanks, that worked!  Is there a reference or guide somewhere that outlines which functions do and do not work as with YEAR()?  Because SUM() worked without any issue and I could not find any resources that said what I should use instead of YEAR().

[Anonymous]

@JLuebbert,

I tried select year(from date_field) but I got the same error message. Perhaps your teradata client somehow translates it into extract(year from date_field)?