I have a zap where I need to upload data to a MySQL database. One field is a datetime field. I used the formatter tool to reformat the datetime into a format that MySQL wants ‘YYYY-MM-DD HH:mm:ss’. The date shows up correctly in the “Data in” side of the zap. However, when it runs, I get an error back for that same field, but it’s now showing extra data at the end. It looks like this '2025-01-28T00:00:00-06:00'
How do I get MySQL to process the datetime in the format that I have input to the zap?