What format do you usually save when it comes to multiple time zones?

to build a system that supports multiple time zones, I was thinking, what format would be better to save the time zone? Is there a standard for this?

  1. "Asia/Shanghai"
  2. "GMT+8"
  3. save an Offset, for example, + 8 is 28800

time stamps are stored directly and output is formatted according to different time zones.

when adding data, the time zone should be uniform


upstairs is right, if the design to the time zone problem, you can not save date. Timestamp is what I think is the best solution


either save it in utc or timestamp

MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1bec33b-31afd.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-1bec33b-31afd.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?