"Leonid Rozenblyum" <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly