[GENERAL] Timezones -- what comes out does not go in?

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" UTC works, of c

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

"Julian Scarfe" <[EMAIL PROTECTED]> 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: inval

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

Julian Scarfe wrote: > 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 fo

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

From: "Tom Lane" <[EMAIL PROTECTED]> This works in CVS HEAD, thanks to some hard work by Joachim Wieland. One of these days I'll find an issue *before* you folks have patched it. :-) Thanks Julian ---(end of broadcast)--- TIP 9: In version