private function getMysqlTimeZoneOffset(string $timezone): string
    {
        $tzUtc = new \DateTimeZone('UTC');
        $tLocal = new \DateTimeZone($timezone);
        $timeUtc = new \DateTime('now', $tzUtc);
        $offsetSeconds = $tLocal->getOffset($timeUtc);
        $offsetHours = $offsetSeconds / 3600;
        $offsetHours = ($offsetHours < 0) ? $offsetHours * -1 : $offsetHours;
        $prefix = ($offsetSeconds < 0) ? '-' : '+';
        return $prefix . sprintf('%02d:00', $offsetHours);
    }