Re: How to get the time zone offset

On Friday, December 30, 2011 6:18:05 am Cezariusz Marek wrote:
> I need to convert timestamp to a format with a time zone offset, like this:
>
> select clock_timestamp()::text;
>
> and it returns the following value:
>
> "2011-12-30 11:59:06.538+01"
>
> What is the default format for timestamp::text conversion? I've tried this:
>
> select to_char(clock_timestamp(), 'YYYY-MM-DD HH24:MI:SSTZ');
>
> But it gives me "CET" instead of "+01":
>
> "2011-12-30 11:59:06CET"

Maybe I am not understanding what you want, but why not:

select clock_timestamp()::text;

It gives you the format you want.

--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com