MySQL 5.6 individual timezones for each database

Question

How can I set individual timezone for each database on MySQL server?

Is it possible that for each table in one database can change timesamp (i.e. EST) keep same and for another tables in another database keep same time stamp (i.e. UTC)

Do anyone have such experience?

Many Thanks,

This might be of some help : http://stackoverflow.com/questions/13916747/set-mysql-database-timezone-to-gmt — Egalitarian, Dec 25 '13 at 09:10

score 1 · Answer 1 · answered Dec 25 '13 at 09:16

1

Timestamps are stored in UTC. Timezones can be set on a per-connection basis. Timestamps are converted to UTC for storage and converted back to the connection timezone for retrieval. There is no finer grained setting.

answered Dec 25 '13 at 09:16

Oswald

31,254
3
43
68

MySQL 5.6 individual timezones for each database

1 Answers1