On Wednesday, July 11, 2018, David Gauthier <davegauthie...@gmail.com> wrote:
> OK, the "to_char" gets rid of the timezone extension. But the times still > don't make sense. > > When I go to store this in a DB, I want to store the UTC time. How d I do > that ? > Use the data type that represents exactly that, timestamptz. Using the timestamp data type is generally not what you want even if you can get the manipulation logic figured out. David J.