Hello there, I am new to Node-Red but I like the idea and possiblilities very much. With my very first project, I tried to implement the "Log MQTT to MySQL" flow (Log MQTT to MySQL (flow) - Node-RED)
But I haven´t get it to work so far, I keep getting this error code
"Error: ER_TRUNCATED_WRONG_VALUE: Incorrect datetime value: '2020-02-06T09:55:33.184Z' for column 'timestamp' at row 1"
I have been looking all over the place to find a solution, it seems, that a lot of people have the same problem, but the simple answer, how to change the ISO-timestamp to something, that MySQL accepts, did not show up (or did I simply not find).
Which function can I use instead of
out = out + "VALUES ('" + new Date().toISOString() + "','"
I appreciate any help,