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

<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>