TimeZone.php
authorleon <leon@roojs.com>
Fri, 29 Sep 2023 03:05:30 +0000 (11:05 +0800)
committerleon <leon@roojs.com>
Fri, 29 Sep 2023 03:05:30 +0000 (11:05 +0800)
TimeZone.php

index fc1cbf9..a9b9b79 100644 (file)
@@ -19,7 +19,7 @@ class Pman_Core_TimeZone extends Pman
         $ce = DB_DataObject::factory('core_enum');
         $ce->query('
             SELECT
-                *
+                *, TIME_FORMAT(TIMEDIFF(NOW(), CONVERT_TZ(NOW(), Name, "UTC")), "%H:%i") as offset
             FROM
                 mysql.time_zone_name
         ');