[GENERAL] How to get the time zone offset

amp(), '-MM-DD HH24:MI:SSTZ'); But it gives me "CET" instead of "+01": "2011-12-30 11:59:06CET" -- ________ Cezariusz Marek   mob: +48 608 646 494

Re: [GENERAL] How to get the time zone offset

Adrian Klaver wrote: > 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:0

[GENERAL] How to get the time zone offset

Y-MM-DD HH24:MI:SSTZ'); But it gives me "CET" instead of "+01": "2011-12-30 11:59:06CET" -- ________ Cezariusz Marek   mob: +48 608 646 494

[GENERAL] How to get the time zone offset using to_char

Y-MM-DD HH24:MI:SSTZ'); But it gives me "CET" instead of "+01": "2011-12-30 11:59:06CET" -- Cezariusz Marek    http://midicat.net/ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] How to get the time zone offset using to_char

Y-MM-DD HH24:MI:SSTZ'); But it gives me "CET" instead of "+01": "2011-12-30 11:59:06CET" -- Cezariusz Marekhttp://midicat.net/

[GENERAL] How to get the time zone offset using to_char

Y-MM-DD HH24:MI:SSTZ'); But it gives me "CET" instead of "+01": "2011-12-30 11:59:06CET" -- Cezariusz Marekhttp://midicat.net/

[GENERAL] How to get the time zone offset

Y-MM-DD HH24:MI:SSTZ'); But it gives me "CET" instead of "+01": "2011-12-30 11:59:06CET" -- ________ Cezariusz Marek   mob: +48 608 646 494

Re: [GENERAL] How to get the time zone offset

Cezariusz Marek wrote: > I need to convert timestamp to a format with a time zone offset, like this: > [...] I'm very sorry for multiple posting, those messages were holded because of some filters, and now apparently someone ap