Dealing with timezones in PHP

by

Few months ago we spent some time thinking about this. The technique we ended up with is pretty simple:

  1. Store dates in GMT/UTC (e.g. 0 timezone offset).
  2. Apply current user timezone offset after retrieval from the database (e.g. before showing to the user or whenever you want).

We use Unix timestamps format. But that doesn’t matter.

More Related Contents:

  1. Using PHP data in MySQL [closed]
  2. What are the “standard” timezone abbreviations?
  3. Timezone conversion in php
  4. Automated or regular backup of mysql data
  5. strange character encoding of stored data , old script is showing them fine new one doesn’t
  6. “date(): It is not safe to rely on the system’s timezone settings…”
  7. PDO mysql: How to know if insert was successful
  8. How to loop through a mysql result set
  9. How to successfully rewrite old mysql-php code with deprecated mysql_* functions?
  10. PHP Configuration: It is not safe to rely on the system’s timezone settings [duplicate]
  11. How to get the total number of rows of a GROUP BY query?
  12. Fetching single row, single column with PDO
  13. How to connect to mssql using pdo through PHP and Linux?
  14. php convert datetime to UTC
  15. PHP, MySQL and Time Zones
  16. Is there any way to check the performance of mysql Indexing
  17. IP address storing in MySQL database using PHP [duplicate]
  18. How do I get Greenwich Mean Time in PHP?
  19. Proper Repository Pattern Design in PHP?
  20. retrieve data from db and display it in table in php .. see this code whats wrong with it?
  21. Using LIKE in bindParam for a MySQL PDO Query [duplicate]
  22. How to tell if a timezone observes daylight saving at any time of the year?
  23. Laravel Change Connection Dynamically
  24. How can I easily convert dates from UTC via PHP?
  25. How to find timezone ID from IP address/country name in PHP?
  26. mysqli – fetch_Array error call to a member function fetch_array() on a non-object mysqli [duplicate]
  27. Storing time information: Timezone required?
  28. Different timezone_types on DateTime object
  29. How do I save PHP session data to a database instead of in the file system?
  30. CakePHP switch database (using same datasource) on the fly?

Leave a Comment