Postgres Pro
Downloads
Home   >   mailing lists

Silent Data Manipulation - Time(stamp) w/o Time Zone Literals w/ TZ - Mailing list pgsql-hackers

From David G. Johnston
Subject Silent Data Manipulation - Time(stamp) w/o Time Zone Literals w/ TZ
Date
Msg-id CAKFQuwa_yYniA0mbWq=5TNP9OkAF1HdwV7Fy9tb0-aOmYAOOKQ@mail.gmail.com
Whole thread Raw
Responses Re: Silent Data Manipulation - Time(stamp) w/o Time Zone Literals w/ TZ
List pgsql-hackers
Tree view 
<div dir="ltr"><div class="gmail_default" style="style"><div class="gmail_default" style="style"><span
style="font-family:arial,helvetica,sans-serif">​"​Ina literal that has been determined to be timestamp without time
zone,PostgreSQL will silently ignore any time zone indication. That is, the resulting value is derived from the
date/timefields in the input value, and is not adjusted for time zone.​​"​</span><br /></div><div class="gmail_default"
style="style"><fontface="arial, helvetica, sans-serif"><br /></font></div><div class="gmail_default"
style="style"><fontface="arial, helvetica, sans-serif"><a
href="http://www.postgresql.org/docs/9.3/static/datatype-datetime.html">http://www.postgresql.org/docs/9.3/static/datatype-datetime.html</a></font></div><div
class="gmail_default"style="style"><font face="arial, helvetica, sans-serif"><br /></font></div><div
class="gmail_default"style="style"><font face="arial, helvetica, sans-serif">8.5.1.3 Time Stamps</font></div><div
class="gmail_default"style="style"><font face="arial, helvetica, sans-serif"><br /></font></div><div
class="gmail_default"style="style"><font face="arial, helvetica, sans-serif"><br /></font></div><div
class="gmail_default"style="style"><font face="arial, helvetica, sans-serif">Not exactly a widely impactful decision
butis there harm in emitting a</font></div><div class="gmail_default" style="style"><font face="arial, helvetica,
sans-serif"><br/></font></div><div class="gmail_default" style="style"><font face="arial, helvetica,
sans-serif">"NOTICE:timezone specification ignored"</font></div><div class="gmail_default" style="style"><br
/></div><divclass="gmail_default" style="style">Just got a complaint on -admin about this:</div><div
class="gmail_default"style="style"><br /></div><div class="gmail_default" style="style"><a
href="http://www.postgresql.org/message-id/CACT-NGKQRtBGKOGUMT_goxyKu=yym8ET1Q5my-yjfuWW++uXbA@mail.gmail.com">http://www.postgresql.org/message-id/CACT-NGKQRtBGKOGUMT_goxyKu=yym8ET1Q5my-yjfuWW++uXbA@mail.gmail.com</a><br
/></div><divclass="gmail_default" style="style"><br /></div><div class="gmail_default" style="style">David J.</div><div
class="gmail_default"style="style"><br /></div></div></div>

pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: BRIN range operator class
Next
From: Stephen Frost
Date:
Subject: Re: Multi-xacts and our process problem