"Julian Scarfe" <julian@xxxxxxxxxxx> 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
