Postgres Pro
Downloads
Home   >   mailing lists

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

From Adrian Klaver
Subject Re: timestamp (military) at time zone without the suffix
Date
Msg-id b1accfd6-9e9d-b3ff-bddf-5560fb19a679@aklaver.com
Whole thread Raw
In response to timestamp (military) at time zone without the suffix  (David Gauthier <davegauthierpg@gmail.com>)
List pgsql-general
Tree view 
On 07/11/2018 12:36 PM, David Gauthier wrote:
> select now()::timestamp(0) at time zone 'utc' ;
Or:

test=> select now();
               now
-------------------------------
  2018-07-11 12:51:50.498416-07
(1 row)

test=>  select now()::timestamptz(0) at time zone 'utc' ;
       timezone
---------------------
  2018-07-11 19:51:52
(1 row)


-- 
Adrian Klaver
adrian.klaver@aklaver.com

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: timestamp (military) at time zone without the suffix
Next
From: Tom Lane
Date:
Subject: Re: timestamp (military) at time zone without the suffix