Re: timestamp (military) at time zone without the suffix

[Adrian Klaver]

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.kla...@aklaver.com