"Leonid Rozenblyum" <[EMAIL PROTECTED]> writes:
> select to_timestamp( '05 Dec 2000 00:00 UTC', 'DD Mon 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
-
The following bug has been logged online:
Bug reference: 3835
Logged by: Leonid Rozenblyum
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.0.14
Operating system: Linux
Description:TZ doesn't work
Details:
I need to convert string with timezone into timestamp