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.
INFORMATION_SCHEMA.COLUMNS
table, columnCOLUMN_DEFAULT
. More info - dev.mysql.com/doc/refman/5.1/en/columns-table.htmltimestamp
columns or do you want toALTER
them?