OK, the "to_char" gets rid of the timezone extension. But the times still don't make sense.
UTC should be 5 hours ahead, not behind. It should be EST plus 5 hours (or 4 for DST), not minus. That's why I said I expected 20:27 .
When I go to store this in a DB, I want to store the UTC time. How d I do that ?
insert into foo (dt) values (localtimestamp(0) at time zone 'utc') ???