From: | "Cezariusz Marek" <cezariusz(dot)marek(at)comarch(dot)pl> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | How to get the time zone offset |
Date: | 2011-12-30 11:04:46 |
Message-ID: | 77C8107E78F740448C9D890246E2BC88@co382.comarch.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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 mob: +48 608 646 494
http://www.comarch.com/ tel: +48 33 815 0734
____________________________________________________________________
From | Date | Subject | |
---|---|---|---|
Next Message | Cezariusz Marek | 2011-12-30 11:22:48 | How to get the time zone offset using to_char |
Previous Message | Alexander Farber | 2011-12-30 10:03:24 | Re: Verifying a timestamp is null or in the past |