> The really serious problem with this is the assumption that the server
> has the same set of available timezones (and spellings of same) as the
> client does.
timezones seriously suck.
China uses CST. So does North America. How you gonna resolve THAT ?
The proper solution is to use "ISO" time with -07 / +08 kinda timezones if you
need to get data in/out of timestampz fields.... Java can do this just by
specifying the right option when you convert a calendar time to a string.