[Christian Kleinschroth]

6 years, 7 months ago #16511

Up

0

Down

::

Hello @anuragkumar,

we don’t support Date for SQL Queries – so please adopt your query parameter to String see example below:

 

INSERT INTO person (name, age,graduatedOn,birth_date_time,isAlive)
VALUES (:name:, :age:Integer:, :graduatedOn:String:,:birth_date_time:String:, :isAlive:);

and ensure that the Date will be formatted correctly. You can do this with moment.js in server side business objects like

moment().format("YYYY-MM-DD")

For further questions, don’t hestitate to reply