Skip to main content
Question

Zap is reformatting DateTime field when transmitting to mysql

  • February 2, 2025
  • 1 reply
  • 6 views

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?

Did this topic help you find an answer to your question?

1 reply

  • Zapier Staff
  • 38 replies
  • February 3, 2025

Hey ​@data_guru 👋 Welcome to the Community!

To better assist you, could you share a screenshot of how the Formatter step is configured? It is possible that the “To Format” field has a different format selected, instead of the one you are looking for. 

Let me know that you find.