On 2011-01-18, araza@esri.com <araza@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