{{NOW_UTC}} time issues in MySQL saving from Wappler node project

I have server action which basically creates an account and part of the account it adds in the current time, which I will use to track the trial period for the account.

However, on saving the form for registration and initiating that action the datetime insert into MYSQL throws an error and can’t work out why :worried:

message: "insert into Account (confirmed, expiry, type) values (‘No’, ‘2020-10-08T23:42:38.000Z’, ‘Admin’) - ER_TRUNCATED_WRONG_VALUE: Incorrect datetime value: ‘2020-10-08T23:42:38.000Z’ for column ‘expiry’ at row 1

I have the database field set to datetime I have done a bit of a search and found similar issues on saving in node.js and mention of correctly formatting to save.

However, I am not sure how to o this and assume that you should have to do that in Wappler, so perhaps something else is going on or I am doing incorrectly?

Can anyone provide some light?

Community Page
Last updated: