On 2011-01-18, ar...@esri.com <ar...@esri.com> wrote: > Hi, > > How can I get timezone name? > I can get timezone offset but I could not find any reference of timezone > name.
Change your datestyle setting, a setting of ISO gives nice portable offsets that will work the same anywhere in the world. a setting of SQL gives a locale-dependant rendering that looks nice but is often ambiguous > 1- > sde10=> Select current_timestamp - current_timestamp AT TIME ZONE 'UTC' As > TimeZoneOffSet; > timezoneoffset > ---------------- > -08:00:00 > (1 row) What do you think the above is doing? Is the following of any use to you? set datestyle to 'sql,mdy'; select current_timestamp; -- ⚂⚃ 100% natural -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general