topic Re: SQL statement for updating UDF Date field in Application Development and Automation Discussions

SQL statement for updating UDF Date field

rwong_gnb — Tue, 08 Oct 2019 21:01:11 GMT

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!

Re: SQL statement for updating UDF Date field

Former Member — Wed, 09 Oct 2019 06:32:53 GMT

Please use date format as 'YYYY-MM-DD'. Refer below SQL.

UPDATE T0 
SET T0."U_Test" = '2019-12-12' 
FROM <DATABASE>.OWOR T0 
WHERE T0."DocNum" = 21568

Re: SQL statement for updating UDF Date field

rwong_gnb — Wed, 09 Oct 2019 15:48:14 GMT

That was very helpful - thank you!