Postgres Pro
Downloads
Home   >   mailing lists

selecting timestamp - Mailing list pgsql-general

From chris
Subject selecting timestamp
Date
Msg-id 32ecec3a-654d-25e5-75ea-ccd7e2331429@pgsqlrocket.com
Whole thread Raw
Responses Re: selecting timestamp  (Adrian Klaver <adrian.klaver@aklaver.com>)
Re: selecting timestamp  ("David G. Johnston" <david.g.johnston@gmail.com>)
Re: selecting timestamp  (Joe Conway <mail@joeconway.com>)
List pgsql-general
Tree view

What is the best way of selecting current timestamp in UTC? 

SELECT
CURRENT_TIMESTAMP   as ct1
,timezone('UTC',CURRENT_TIMESTAMP) as ct2
,timezone('utc',now()) as ct3
,CURRENT_TIMESTAMP at time zone 'UTC' as ct4
,NOW() at time zone 'utc' as ct5

pgsql-general by date:

Previous
From: Greg Stark
Date:
Subject: Re: Feature request: separate logging
Next
From: Adrian Klaver
Date:
Subject: Re: selecting timestamp