commutebanner=# set timezone='us/central';
SET
commutebanner=# select date('2016-10-20T01:01:00Z');
-[ RECORD 1 ]----
date | 2016-10-20

commutebanner=# select '2016-10-20T01:01:00Z'::timestamptz at time zone 'us/central';
-[ RECORD 1 ]-----------------
timezone | 2016-10-19 20:01:00