From: | Jasen Betts <jasen(at)xnet(dot)co(dot)nz> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: How to get TimeZone name? |
Date: | 2011-01-28 22:01:02 |
Message-ID: | ihveau$92r$1@reversiblemaps.ath.cx |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Jasen Betts | 2011-01-28 22:41:44 | Re: searching for characters via the hexidecimal value |
Previous Message | Herouth Maoz | 2011-01-28 21:12:31 | Adding more space, and a vacuum question. |