时区数据库 将gmt_offset转换为 +5:30 格式

Question

这是我的链接：

http://timezonedb.com/download

 timezone.csv
 Fields: "zone_id","abbreviation","time_start","gmt_offset","dst"

"370","CDT","-273686400","-18000","1"    
"370","EST","-266432400","-18000","0"
"370","EDT","-52938000","-14400","1"    
"370","EST","-37216800","-18000","0"
"370","EDT","-21488400","-14400","1"
"370","EST","-5767200","-18000","0"
"370","EDT","9961200","-14400","1"
"370","EST","25682400","-18000","0"
"370","EDT","41410800","-14400","1"
"370","EST","57736800","-18000","0"

如您所见，它将与时间相关的数据作为一些大数字给出，我如何将其转换为"UTC+5：30"小时格式......
谢谢

Answer 1

除以

3600（一小时中的秒数）得到以小时为单位的 UTC 偏移量