Request a Demo
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
Responses Re: Silent Data Manipulation - Time(stamp) w/o Time Zone Literals w/ TZ
List pgsql-hackers
Tree view
​"​In a 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/time fields in the input value, and is not adjusted for time zone.​​"​

http://www.postgresql.org/docs/9.3/static/datatype-datetime.html

8.5.1.3 Time Stamps


Not exactly a widely impactful decision but is there harm in emitting a

"NOTICE: timezone specification ignored"

Just got a complaint on -admin about this:

http://www.postgresql.org/message-id/CACT-NGKQRtBGKOGUMT_goxyKu=yym8ET1Q5my-yjfuWW++uXbA@mail.gmail.com

David J.

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