When I connect to mysql for union queries with redash, the time fields of my tables A,B, and C are 2019-06-05, and the SQL outermost merge is 13-digit

That’s missing a few details, for being able to solve this. :wink:

Would you be ok to add?

  • the SQL query that’s not working correctly
  • what the result from it is, at the moment
  • what you’re aiming for it to do instead