On May 12, 2015, at 5:49 PM, Robert Burgholzer <rburghol@xxxxxx> wrote: > > to_timestamp translates into the local TZ Always. No, it translates to UTC, but timestamps by default display in your local timezone. Look at your example, the result of to_timestamp is midnight UTC as expected, which in your time zone is 19:00. -- Scott Ribe scott_ribe@xxxxxxxxxxxxxxxx http://www.elevated-dev.com/ https://www.linkedin.com/in/scottribe/ (303) 722-0567 voice -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
