| ... | ... | @@ -129,6 +129,24 @@ CiviCRM is an application/framework/platform that integrates with several other |
|
|
|
* _Settings_: Does not provide its own timezone setting. Inherits the active timezone from Drupal/WordPress. Propagates the setting to MySQL+PHP. (But has a bug here - it propagates the _current offset_ rather than the _timezone_. This misbehaves when crossing a DST boundary.)
|
|
|
|
* _Formats_: Uses MySQL-style strings (`YYYY-MM-DD hh:mm:ss`) and a mix of MySQL `DATETIME`/`TIMESTAMP`. (`DATETIME` for storing nominal perspective; `TIMESTAMP` for universal+personal perspectives.)
|
|
|
|
|
|
|
|
## Appendix: MySQL survey
|
|
|
|
|
|
|
|
There is a substantive question about the quantity/quality of MySQL environments which do/can/cannot enable timezone support. Some references:
|
|
|
|
|
|
|
|
* __Environments which enable timezones by default__
|
|
|
|
* Digital Ocean (Managed MySQL) (`r-run`: yes)
|
|
|
|
* Docker (https://hub.docker.com/_/mysql) (`r-run`: yes)
|
|
|
|
* Google Cloud (Cloud SQL for MySQL) (`r-run`: yes; but ["not guaranteed to provide up-to-date time settings"](https://cloud.google.com/sql/docs/mysql/known-issues))
|
|
|
|
* (_Probably_) Amazon RDS-MySQL (There are old-google-cached forum posts which imply gradual evolution toward support. The current ["Local time zone" page](https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_MySQL.html#MySQL.Concepts.LocalTimeZone) seems to affirm, but it doesn't specifically mention session-scoped timezones.)
|
|
|
|
* __Environments which have the ability to load timezones - but don't by default__
|
|
|
|
* Azure MySQL (https://docs.microsoft.com/en-us/azure/mysql/howto-server-parameters#working-with-the-time-zone-parameter)
|
|
|
|
* CentOS MySQL Packages (`mysql_tzinfo_to_sql`) (`r-run`: yes)
|
|
|
|
* cPanel hosts with root access
|
|
|
|
* Debian/Ubuntu MySQL Packages (`mysql_tzinfo_to_sql`) (`r-run`: yes)
|
|
|
|
* Nix MySQL Packages (`mysql_tzinfo_to_sql`) (`r-run`: yes)
|
|
|
|
* __Environments which cannot load timezones__
|
|
|
|
* (_Probably_) cPanel hosts without root access
|
|
|
|
|
|
|
|
## Related Tasks
|
|
|
|
|
|
|
|
https://lab.civicrm.org/dev/core/-/issues/3152 |
