Re: BUG #3835: TZ doesn't work

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Leonid Rozenblyum" <leokom(at)rambler(dot)ru>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #3835: TZ doesn't work
Date: 2007-12-22 17:44:51
Message-ID: 24882.1198345491@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"Leonid Rozenblyum" <leokom(at)rambler(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Bronnikov Vladimir 2007-12-26 07:15:33 BUG #3839: LDAP authentification and password with "space"-symbol
Previous Message Leonid Rozenblyum 2007-12-22 14:13:03 BUG #3835: TZ doesn't work