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

[Adrian Klaver <adrian.klaver@xxxxxxxxxxx>]

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@xxxxxxxxxxx