How to store a datetime in MySQL with timezone info

by

You said:

I want them to always come out as Tanzanian time and not in the local times that various collaborator are in.

If this is the case, then you should not use UTC. All you need to do is to use a DATETIME type in MySQL instead of a TIMESTAMP type.

From the MySQL documentation:

MySQL converts TIMESTAMP values from the current time zone to UTC for storage, and back from UTC to the current time zone for retrieval. (This does not occur for other types such as DATETIME.)

If you are already using a DATETIME type, then you must be not setting it by the local time to begin with. You’ll need to focus less on the database, and more on your application code – which you didn’t show here. The problem, and the solution, will vary drastically depending on language, so be sure to tag the question with the appropriate language of your application code.

More Related Contents:

  1. How to convert time to the time zone of the iPhone device?
  2. How do I set the time zone of MySQL?
  3. MySQL Query GROUP BY day / month / year
  4. Error in MySQL when setting default value for DATE or DATETIME
  5. MySQL Query to select data from last week?
  6. MySQL convert date string to Unix timestamp
  7. Timestamp with a millisecond precision: How to save them in MySQL
  8. How to select date from datetime column?
  9. MySQL timezone change?
  10. How to convert number of week into date?
  11. Set NOW() as Default Value for datetime datatype?
  12. SQL Query to show nearest date?
  13. How to subtract hours from a datetime in MySQL?
  14. MySQL CONVERT_TZ()
  15. Select data between a date/time range
  16. MySQL compare DATE string with string from DATETIME field
  17. PHP, MySQL and Time Zones
  18. Set timezone in PHP and MySQL
  19. MySql difference between two timestamps in days?
  20. How to cast DATETIME as a DATE in mysql?
  21. Can MySQL convert a stored UTC time to local timezone?
  22. How to get current date & time in MySQL?
  23. MySQL – select data from database between two dates
  24. how to cast the hexadecimal to varchar(datetime)?
  25. MySQL Time Zones
  26. NodeJS responded MySQL timezone is different when I fetch directly from MySQL
  27. Database returned an invalid value in QuerySet.dates()
  28. how to partition a table by datetime column?
  29. MySQL select all rows from last month until (now() – 1 month), for comparative purposes
  30. MySQL – How to parse a string value to DATETIME format inside an INSERT statement?

Leave a Comment