Friday, June 20, 2008

Re: [SQL] "TZ"/"tz" not supported

Are you basically saying that "TZ" can be used in an "output template
string", but not in an "input template string" (in the terminology of
the documentation)? If this is the case, shouldn't this be mentioned
in the documentation? Also, is there a fundamental reason for this
limitation or is it just the implementation waiting to be completed
(nobody has had an itch intensive enough to scratch it)?

Thanks
Peter

On Fri, Jun 20, 2008 at 8:50 AM, A. Kretschmer
<andreas.kretschmer@schollglas.com> wrote:
> am Fri, dem 20.06.2008, um 8:35:10 +0200 mailte Peter Kovacs folgendes:
>> Thank you, Andreas! Your advice is very useful to me.
>>
>> I would still be interested why "TZ" is not accepted in the format string.
>
> I think because TZ is only useful for displaying a timestamptz and not
> for internal representation and/or calculation.
>
> For displaying you can use to_char(timestamptz, format-string).
>
>
> 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
>

--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql

No comments: