Hi,

I am trying to update a column of type date with currentdate using JDBC adapter but myDesign studio is crashing and not responding.

Have tried all the below syntax but not making it run successfully.

GET("JDBC", "-URL <url> -USER <userid> -PASSWORD <pwd>  -TV -QUERY 'update tablename set updated_on =? where id= ?'", ""+FROMDATETIME(CURRENTDATE())+"|1")

GET("JDBC", "-URL <url> -USER <userid> -PASSWORD <pwd>  -TV -QUERY 'update tablename set updated_on =CURRENT_DATE where id= ?'", "1")

GET("JDBC", "-URL <url> -USER <userid> -PASSWORD <pwd>  -TV -QUERY 'update tablename set updated_on =SYSDATE where id= ?'", "1")

GET("JDBC", "-URL <url> -USER <userid> -PASSWORD <pwd>  -TV -QUERY 'update tablename set updated_on =? where id= ?'", "SYSDATE|1")

Please share if anyone has any thoughts on it.

Hi, please send the error message and the name of the database system, because the JDBC driver of the DB manufacturer determines the syntax.
In most cases the cast (conversion) to the correct data type is missing (e.g. Oracle knows functions like to_date(...) or sql server convert(DATETIME, '7/7/2011', 101)