Re: "TZ"/"tz" not supported - Mailing list pgsql-sql

From Peter Kovacs
Subject Re: "TZ"/"tz" not supported
Date
Msg-id b6e8f2e80806192335q2d6402cey62a2cdbf9442a3d0@mail.gmail.com
Whole thread Raw
In response to Re: "TZ"/"tz" not supported  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
Responses Re: "TZ"/"tz" not supported
List pgsql-sql
Thank you, Andreas! Your advice is very useful to me.

I would still be interested why "TZ" is not accepted in the format string.

Thanks
Peter


On Fri, Jun 20, 2008 at 8:15 AM, A. Kretschmer
<andreas.kretschmer@schollglas.com> wrote:
> am  Fri, dem 20.06.2008, um  7:51:50 +0200 mailte Peter Kovacs folgendes:
>> Hi,
>>
>> Execution of the following statement aborts with the error message in
>> the Subject:
>>
>> select to_timestamp('2008-06-20 02:30:00 GMT', 'YYYY-MM-DD HH24:MI:SS TZ');
>
> You can use:
>
> test=*# select '2008-06-20 02:30:00 GMT'::timestamptz;
>      timestamptz
> ------------------------
>  2008-06-20 04:30:00+02
> (1 row)
>
>
>
> helps that?
>
>
>
> Andreas
> --
> Andreas Kretschmer
> Kontakt:  Heynitz: 035242/47150,   D1: 0160/7141639 (mehr: -> Header)
> GnuPG-ID:   0x3FFF606C, privat 0x7F4584DA   http://wwwkeys.de.pgp.net
>
> --
> Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-sql
>


pgsql-sql by date:

Previous
From: "A. Kretschmer"
Date:
Subject: Re: "TZ"/"tz" not supported
Next
From: "A. Kretschmer"
Date:
Subject: Re: "TZ"/"tz" not supported