On 2011-01-18, araza@xxxxxxxx <araza@xxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
