Re: How to get TimeZone name?

On 2011-01-18, araza(at)esri(dot)com <araza(at)esri(dot)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