Hi, I’m trying to move data between two database. One is MySQL and the other Microsoft SQL.
When I try to update a row with a DateTime i’m getting the error
ERROR: Conversion failed when converting date and/or time from character string
I’ve tried to set a new date().toSTRING(), and/or to CAST in a DATETIME, nothing’s working. If I copy paste the “result” in Microsoft SQL and run the row update, it’s working. It looks like N8N does not paste the date as is.
We should be sending the data as it is in the result window there, Do you only have the one input item or is there multiple? Have you tried removing the ' ' from the date as well? I can’t remember if MSSQL has issues with that.
That looks ok to me, I would have expected CAST to work. What happens if you make a test table and set the field to be varchar / text then write the value out? It would be interesting to see what is sent, You could also find this in the tsql log in ssms.