Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #3835: TZ doesn't work - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #3835: TZ doesn't work
Date
Msg-id 24882.1198345491@sss.pgh.pa.us
Whole thread Raw
In response to BUG #3835: TZ doesn't work  ("Leonid Rozenblyum" <leokom@rambler.ru>)
List pgsql-bugs
Tree view 
"Leonid Rozenblyum" <leokom@rambler.ru> writes:
>     select to_timestamp( '05 Dec 2000 00:00 UTC', 'DD Mon YYYY HH24:MI TZ'

Just cast the string to timestamptz.  You only need to_timestamp() for
nonstandard, ambiguous input formats, which this is not.

            regards, tom lane

pgsql-bugs by date:

Previous
From: "Leonid Rozenblyum"
Date:
Subject: BUG #3835: TZ doesn't work
Next
From: "Bronnikov Vladimir"
Date:
Subject: BUG #3839: LDAP authentification and password with "space"-symbol