Hi all,
I have a user-defined field in my Production Order module that is of Date type. I am trying to learn the syntax for updating this field with a new date via SQL.
When I attempt to run this query in HANA Studio:
UPDATE T0 SET T0."U_Test" = '12/12/2019' FROM <DATABASE>.OWOR T0 WHERE T0."DocNum" = 21568
I get this error:
Could not execute 'UPDATE T0 SET T0."U_Test" = '12/12/2019' FROM <DATABASE>.OWOR T0 WHERE T0."DocNum" = 21568' SAP DBTech JDBC: [2]: general error: prepare UPDATE failed.
is there a specific format that the date string needs to be or am I missing something else?
Thanks for any help you can give!