The following bug has been logged online:...
The timezone designation SGT is not recognized on inserts to "timestamp with
time zone" fields.
...
fyi, I am on this list, if anyone wants to tell me I'm way off base here or whatever :)
something tells me I'm going to hit this problem again when our app gets deployed at our plants in thailand and china and indonesia (and, no, I don't yet know what time zone codes they use, I'm trying to figure out how to dump the linux timezone files)
ok, on my redhat enterprise linux server, /usr/share/zoneinfo/Asia/Bangkok uses ICT which is defined.
however, mainland china, ugh.
CN Asia/Shanghai east China - Beijing, Guangdong, Shanghai, etc. CN Asia/Harbin Heilongjiang CN Asia/Chongqing central China - Gansu, Guizhou, Sichuan, Yunnan, etc. CN Asia/Urumqi Tibet & most of Xinjiang Uyghur CN Asia/Kashgar southwest Xinjiang Uyghur
Asia/Shanghai Thu Aug 26 08:29:36 2004 CST Asia/Harbin Thu Aug 26 08:29:36 2004 CST Asia/Chongqing Thu Aug 26 08:29:36 2004 CST Asia/Urumqi Thu Aug 26 08:29:36 2004 CST Asia/Kashgar Thu Aug 26 08:29:36 2004 CST
so all of china uses CST, which is *NOT* CST as we know it here in North America ;-/
*UGH*
(btw, thats the trimmed output of... $ grep ^CN /usr/share/zoneinfo/zone.tab and $ cd /usr/share/zoneinfo; /usr/sbin/zdump Asia/* )
---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
