| 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: | Whole Thread | Raw Message | 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 |