Is timestamp in mysql cached when retrieved in dif

2019-08-10 22:24发布

In the MySQL 5.6 Manual, it says:

MySQL converts TIMESTAMP values from the current time zone to UTC for storage, and back from UTC to the current time zone for retrieval.

but if I have different connections with different timezones, will the timestamp value be cached?

1条回答
放我归山
2楼-- · 2019-08-10 22:46

According to OZ_ here:

Another one difference: queries with "native" datetime will not be cached, but queries with timestamp - will be. – OZ_ Apr 28 '11 at 17:37

But I cannot find any confirmation of this by Googling, and he doesn't provide a link.

查看更多
登录 后发表回答