2009/2/26 Daniel Verite :
> Pavel Stehule wrote:
>
>> > Is there a format string for to_char(timestamptz, text) that would
>
> output a
>>
>> > timestamp in full ISO-8601 format? That is, something like
>> > 1977-04-22T01:00:00-05:00
>> >
>> > I can't find a way to extract the offset against
Sam Mason wrote:
1) values of type "timestamp with time zone" are always converted
to UTC (either using the timezone specified or using the session's
current "timezone" value) and then when they're sent back to the
value
is then corrected to the session's timezone (or an expli
Pavel Stehule wrote:
> Is there a format string for to_char(timestamptz, text) that would
output a
> timestamp in full ISO-8601 format? That is, something like
> 1977-04-22T01:00:00-05:00
>
> I can't find a way to extract the offset against GMT from the docs
here:
> http://www.postg
On Thu, Feb 26, 2009 at 10:50:18AM +0100, Daniel Verite wrote:
> Is there a format string for to_char(timestamptz, text) that would
> output a timestamp in full ISO-8601 format? That is, something like
> 1977-04-22T01:00:00-05:00
If I'm understanding correctly, that's a bit awkward to do. PG on
Hello
2009/2/26 Daniel Verite :
> Hi,
>
> Is there a format string for to_char(timestamptz, text) that would output a
> timestamp in full ISO-8601 format? That is, something like
> 1977-04-22T01:00:00-05:00
>
> I can't find a way to extract the offset against GMT from the docs here:
> http://www.p
Hi,
Is there a format string for to_char(timestamptz, text) that would
output a timestamp in full ISO-8601 format? That is, something like
1977-04-22T01:00:00-05:00
I can't find a way to extract the offset against GMT from the docs
here:
http://www.postgresql.org/docs/8.3/static/functions-f
