Changeset 654 for trunk/lib/DB.inc.php

Timestamp:

Jan 24, 2019 7:13:52 PM (5 years ago)

Author:

anonymous

Message:

Add timezone support

File:

• trunk/lib/DB.inc.php (modified) (1 diff)

trunk/lib/DB.inc.php

@@ -201 +201 @@
         }
 
+        // Set timezone.
+        $tz = date_default_timezone_get();
+        // Check that PHP is configured with a valid timezone name, e.g., "UTC" or "America/Chicago".
+        if ($app->getParam('timezone') && $app->getParam('timezone') == $tz && preg_match('![A-Z]{3,}|\w+/\w+!', $tz)) {
+            $this->query(sprintf("SET SESSION time_zone = '%s'", $tz));
+        }
+
         return true;
     }