Forum

Christian Kleinschroth
      Has successfully completed the online course Introduction
      Has successfully completed the online course Intermediate (200)
      Has successfully completed the online course Advanced (300)
      Has successfully completed the online course Basics (100)
      Has successfully completed the online course Advanced (310)
      Has successfully completed the online course Advanced (320)
      Has successfully completed the Intermediate Certification
      Has successfully completed the Advanced Certification
    5 years 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