Can you change our MySQL server's system time zone to be in my region-specific time zone? It is currently set to UTC.
MySQL is provided as part of a standardized Acquia platform, and as such the timezone is set to UTC. If it is necessary for queries to be in time zones other than UTC, we recommend implementing time zone calculation in logic added to your PHP code surrounding your queries.
Time zones are set at a platform level. None of Acquia's systems are designed to keep the time zone info up-to-date in MySQL, so we are unable to provide manual adjustments to the database servers as requested.