Home > database >  Mysql time question
Mysql time question

Time:10-02

Question: I now use datatime mysql storage time of field type, server code in Java. Util. The Date (s) (the current time) storage, that is,
Any time zone, and ultimately storage are access server the current time, so when the show time, time is uniform, with foreign clients
Agreement to access at the same time, the final time stored in the database are consistent, no concept of time zones, now I want to let time display and time zones, with a
Time to access the server, such as the east eight area display at 8 o 'clock, ten east area is displayed at 10 a.m., how to change to achieve such effect?

CodePudding user response:

Take out the data according to adjust the client time zone
It's not mysql

CodePudding user response:

Storage is current access server time???????

First to save time when I was wrong, don't put the server time put into the eastern area 0 seconds of the time
  • Related