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
Yes you can , now() returns current date time as output so not sure why you have this doubt in first place
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 .
rudraksht548412 Yes it works, now() can be used to capture the datetime in DB
Thank you
rudraksht548412 Yes it works, function Now() already show the correct date & time with converted timezone.