On Tue, May 12, 2015 at 10:33 AM, Robert Burgholzer <rburghol@vt.edu> wrote:
Thoughts on this? To me, it would seem intuitive that if you did not specify a timezone, the db would choose it's own local timestamp as the timezone.
The timezone info is truncated.
From the documentation:
"
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.