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

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