Skip to Content
0
Former Member
Aug 04, 2016 at 12:01 PM

SAP HANA Invalid expression SAP DBTech JDBC [293]

716 Views

Hi All,

I´m trying to create a calculated column to get the week of the current date ( week(now)), but when i change the language from Column Engine to SQL to have the functions availables i get the following error:

i try to make the same query in SQL editor (SELECT WEEK (CURRENT_DATE) "week" FROM DUMMY; ) and it worked fine.

Can you please help me?

Thanks

Attachments

error.png (82.3 kB)