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

I need a real-time clock value so I will use clock_timestamp() to get it.
Thanks for the answer.

2013/1/15 Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>

> dotbrat(at)gmail(dot)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
>