1

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?

user2335065
  • 2,337
  • 3
  • 31
  • 54

1 Answers1

1

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.

Community
  • 1
  • 1
NobleUplift
  • 5,631
  • 8
  • 45
  • 87