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

The following bug has been logged on the website:

Bug reference:      7804
Logged by:          Ruslan Izmaylov
Email address:      dotbrat@gmail.com
PostgreSQL version: 9.1.7
Operating system:   Fedora release 17
Description:        =


Query:

SET TIME ZONE 'Europe/Minsk';
select timeofday()::timestamp with time zone;

Result:

ERROR: invalid input syntax for type timestamp with time zone: "Mon Jan 14
08:18:20.333915 2013 FET"
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

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

From
Руслан Измайлов
Date:
<div dir="ltr"><font face="arial, helvetica, sans-serif">I need a real-time clock value so I will use <span
style="color:rgb(0,0,0);font-size:12px;line-height:18.234375px">clock_timestamp()to get it. Thanks for the
answer.</span></font><br/><div dir="ltr"><div class="gmail_extra"><br /><br /><div class="gmail_quote">2013/1/15 Tom
Lane<span dir="ltr"><<a href="mailto:tgl@sss.pgh.pa.us" target="_blank">tgl@sss.pgh.pa.us</a>></span><br
/><blockquoteclass="gmail_quote" style="margin:0px 0px 0px
0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex"><a
href="mailto:dotbrat@gmail.com">dotbrat@gmail.com</a>writes:<br /> > SET TIME ZONE 'Europe/Minsk';<br /> > select
timeofday()::timestampwith time zone;<br /> > ERROR: invalid input syntax for type timestamp with time zone: "Mon
Jan14<br /> > 08:18:20.333915 2013 FET"<br /><br /> The issue seems to be that the recently-invented abbreviation
FET<br/> isn't anywhere in our default list of timezone abbreviations.<br /><br /> That probably should be fixed, but
inthe meantime, you really should be<br /> aware that timeofday() is deprecated, and there's no reason at all to<br />
useit in the above manner anyway.  now() or current_timestamp are<br /> simpler and much faster.<br /><br />          
             regards, tom lane<br /></blockquote></div><br /></div></div></div>