/** * Set timezone in mysql so that timestamp fields show the correct time. */ public function setMySQLTimeZone() { $timeZoneOffset = $this->getTimeZoneOffset(); if ($timeZoneOffset) { $sql = "SET time_zone = '{$timeZoneOffset}'"; CRM_Core_DAO::executequery($sql); } }