Re: How to get the time zone offset

On Friday, December 30, 2011 8:19:51 am Cezariusz Marek wrote:

>
> Is the timestamp::text format always the same, regardless of the current
> locale and language settings?

Now I have an answer. It can be changed via the DateStyle setting in postgresql.conf

http://www.postgresql.org/docs/9.1/interactive/runtime-config-client.html#RUNTIME-CONFIG-CLIENT-FORMAT

So for my previous setting of (iso,mdy) I got:

test(5432)postgres=#select clock_timestamp()::text;
        clock_timestamp
-------------------------------
 2011-12-30 08:56:39.019038-08

Changing the setting to (sql,mdy) resulted in:

test(5432)postgres=#select clock_timestamp()::text;
        clock_timestamp
--------------------------------
 12/30/2011 08:55:48.554618 PST



--
Adrian Klaver
adrian.klaver@gmail.com