SQL##f - SqlState: S0022, ErrorCode: 904, ErrorMsg: [Oracle][ODBC][Ora]ORA-00904: "YEAR": invalid identifier

[vireshkolagimat]

Hi All,

I am trying to load the below script but getting the error message as

" SQL##f - SqlState: S0022, ErrorCode: 904, ErrorMsg: [Oracle][ODBC][Ora]ORA-00904: "YEAR": invalid identifier".

script: LET vIncrementalExpression = 'Where a.customer not in (''A'',''B'',''C'') and  YEAR (salhist.dated) >= Year (GETDATE ()) - 3';

Thank You.

Regards,

Viresh

[vireshkolagimat · Accepted solution]

Hi All,

I got the answer. when you query YEAR (INVOCIEDATE) is not valid in oracle. so i tried EXTRACT (YEAR from INVOICEDATE) and its working fine.

Thank you all.

Regards,

Viresh