Thank you everyone for the help.
Sorry there wasn't much detail given originally.
CURRENT_TIMESTAMP at time zone 'UTC' as ct4
Seems to be working well.
Thanks,
Chris
On 02/27/2018 01:26 PM, David G. Johnston wrote:
On Tue, Feb 27, 2018 at 1:16 PM, chris <chr...@pgsqlrocket.com
<mailto:chr...@pgsqlrocket.com>>wrote:
What is the best way of selecting current timestamp in UTC?
You
haven't
define
d
criteria upon which to judge - and the list below is not exhaustive
(but sufficiently so)
SELECT
CURRENT_TIMESTAMP as ct1
standard conforming, assumes server configured for UTC
,timezone('UTC',CURRENT_TIMESTAMP) as ct2
,timezone('utc',now()) as ct3
non-standard, personally non-obvious (the function looks like an
implementation detail that should be avoided)
,CURRENT_TIMESTAMP at time zone 'UTC' as ct4
This -
standard conforming and doesn't require assumptions about the calling
environment
,NOW() at time zone 'utc' as ct5
non-standard but frequently used; no semantic different compared to
the previous entry
David J.
