Re: timestamp (military) at time zone without the suffix - Mailing list pgsql-general

From David G. Johnston
Subject Re: timestamp (military) at time zone without the suffix
Date
Msg-id CAKFQuwY8Z-vnPMRncLu+V+byjVi7a3pHs1p=0kjQQ74cmBmsgg@mail.gmail.com
Whole thread Raw
In response to Re: timestamp (military) at time zone without the suffix  (David Gauthier <davegauthierpg@gmail.com>)
Responses Re: timestamp (military) at time zone without the suffix  (David Gauthier <davegauthierpg@gmail.com>)
List pgsql-general
On Wednesday, July 11, 2018, David Gauthier <davegauthierpg@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. 

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: timestamp (military) at time zone without the suffix
Next
From: Christopher Browne
Date:
Subject: Re: Open Source tool to deploy/promote PostgreSQL DDL