for latest
https://timezonedb.com/files/timezonedb.sql.zip
PHP Code:
SELECT (strftime('%%s',DATETIME('now', 'utc')) + `gmt_offset`), `dst`, `gmt_offset` \
FROM `time_zone` \
WHERE `time_start` <= strftime('%%s',DATETIME('now', 'utc')) AND `zone_name` = '%s' \
ORDER BY `time_start` DESC LIMIT 1;
->
PHP Code:
SELECT (strftime('%%s',DATETIME('now', 'utc')) + `gmt_offset`), `dst`, `gmt_offset` \
FROM `timezone` \
JOIN `zone` ON `timezone`.`zone_id`=`zone`.`zone_id`\
WHERE `time_start` <= strftime('%%s',DATETIME('now', 'utc')) AND `zone_name` = '%s' \
ORDER BY `time_start` DESC LIMIT 1;