Quick Links

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

From:	Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To:	"Julian Scarfe" <julian(at)avbrief(dot)com>
Cc:	pgsql-general(at)postgresql(dot)org
Subject:	Re: Timezones -- what comes out does not go in?
Date:	2006-08-16 14:19:25
Message-ID:	19751.1155737965@sss.pgh.pa.us
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-general

"Julian Scarfe" <julian(at)avbrief(dot)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.

regards, tom lane

	From	Date	Subject
Next Message	Alvaro Herrera	2006-08-16 14:22:13	Re: Timezones -- what comes out does not go in?
Previous Message	Peter Nixonn	2006-08-16 14:18:07	Weird join result