Re: BUG #7804: timeofday() output string is not compatible with "timestamp with time zone" data type - Mailing list pgsql-bugs

dotbrat@gmail.com writes:
> SET TIME ZONE 'Europe/Minsk';
> select timeofday()::timestamp with time zone;
> ERROR: invalid input syntax for type timestamp with time zone: "Mon Jan 14
> 08:18:20.333915 2013 FET"

The issue seems to be that the recently-invented abbreviation FET
isn't anywhere in our default list of timezone abbreviations.

That probably should be fixed, but in the meantime, you really should be
aware that timeofday() is deprecated, and there's no reason at all to
use it in the above manner anyway.  now() or current_timestamp are
simpler and much faster.

            regards, tom lane