I wanted to fill a table in sql, one of the fields in the CDT is action_performed_on, and for that i decided to use the now function to put the value, but I am not sure whether it is compatible with the DATETIME data type of the column. Will it work, or is there some other option to make that happen without it giving any error.
Discussion posts and replies are publicly visible
Also does appian does that conversion automatically (from now() format to DATETIME in SQL), or some other procedure needs to be applied
Nothing needed , Appian will do the all the work for you in backend it will create the insert/update queries and it will take care of all the conversions for you .
Thank you