Re: [BUGS] BUG #3835: TZ doesn't work

2007-12-22 Thread Tom Lane
"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 -

[BUGS] BUG #3835: TZ doesn't work

2007-12-22 Thread Leonid Rozenblyum
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