Forum Discussion

JLuebbert's avatar
JLuebbert
Regular Visitor
8 years ago
Solved

Teradata Import Query Error

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...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    JLuebbert,

    Can you try SELECT EXTRACT(YEAR FROM DATE_FIELD)?

JLuebbert's avatar
JLuebbert
Regular Visitor
8 years ago

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's avatar
Anonymous
Not applicable
8 years ago

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)?