Re: Timezones -- what comes out does not go in?

"Julian Scarfe" <julian@avbrief.com> writes:
> The timezone on our boxes is set to Etc/UCT (possibly a distro default).
> (psql 8.1.4)

> => select to_char(current_timestamp, 'HH24:MI:SS TZ');
>    to_char
> --------------
>  09:05:48 UCT
> (1 row)

> =>  select '09:05:48 UCT'::time;
> ERROR:  invalid input syntax for type time: "09:05:48 UCT"

This works in CVS HEAD, thanks to some hard work by Joachim Wieland.

http://archives.postgresql.org/pgsql-patches/2006-07/msg00077.php
http://archives.postgresql.org/pgsql-committers/2006-07/msg00258.php

            regards, tom lane