How to get the time zone offset using to_char - Mailing list pgsql-general

From Cezariusz Marek
Subject How to get the time zone offset using to_char
Date
Msg-id CANRnGAYm0L2yi+gXaue0M4VmHFZqU1RLeOTUcUD+v997tdndCg@mail.gmail.com
Whole thread Raw
List pgsql-general

I need to convert timestamp to a format with a time zone offset, like this:

select clock_timestamp()::text;

which returns:

"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"


--
Cezariusz Marek    http://midicat.net/

pgsql-general by date:

Previous
From: Cezariusz Marek
Date:
Subject: How to get the time zone offset using to_char
Next
From: "Cezariusz Marek"
Date:
Subject: How to get the time zone offset