What is the best way of selecting current timestamp in UTC?
You
haven't
defined
criteria upon which to judge - and the list below is not exhaustive (but sufficiently so)
SELECTCURRENT_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.
