Skip to Content
0
Oct 08, 2019 at 09:01 PM

SQL statement for updating UDF Date field

863 Views

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!