Skip site navigation (1) Skip section navigation (2)

Re: "TZ"/"tz" not supported

From: "Peter Kovacs" <maxottovonstirlitz(at)gmail(dot)com>
To: "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: "TZ"/"tz" not supported
Date: 2008-06-20 06:35:10
Message-ID: b6e8f2e80806192335q2d6402cey62a2cdbf9442a3d0@mail.gmail.com (view raw or flat)
Thread:
Lists: 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(dot)kretschmer(at)schollglas(dot)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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-sql
>

In response to

Responses

pgsql-sql by date

Next:From: A. KretschmerDate: 2008-06-20 06:50:21
Subject: Re: "TZ"/"tz" not supported
Previous:From: A. KretschmerDate: 2008-06-20 06:15:18
Subject: Re: "TZ"/"tz" not supported

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group