I am trying to internationalize a database, but there are places where the
timestamp that gets set is using
NOW() instead of
UTC_TIMESTAMP(), and it's using Amazon's RDS with multiple
MySQL servers. The problem is that each is on their own timezone and this creates a mess of disentangling the various timezones, translating them to UTC, and then re-translating them back to the users timezone.
This database has some 140+ tables and I'd like something more efficient than searching manually by using
SHOW CREATE on each table, plus I'd like to be able to check when I'm done that everything was converted correctly .
Any ideas on a query that would do this?
To be clear, I'm looking for a query to
SELECT the rows that I need, I can figure out a
INSERT... SELECT statement from that.