Home > mailing lists

Re: selecting timestamp - Mailing list pgsql-general

From	David G. Johnston
Subject	Re: selecting timestamp
Date	February 28, 2018 02:26:27
Msg-id	CAKFQuwZ3DYbuFwP+HAmEyPcf29adBFHJ5ME4jSOWzeuhnwN5cA@mail.gmail.com Whole thread Raw
In response to	selecting timestamp (chris <chrisk@pgsqlrocket.com>)
Responses	Re: selecting timestamp (chris <chrisk@pgsqlrocket.com>)
List	pgsql-general

On Tue, Feb 27, 2018 at 1:16 PM, chris <chrisk@pgsqlrocket.com> wrote:

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

You

haven't

define

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.

From: Adrian Klaver
Date: 28 February 2018, 02:25:20
Subject: Re: selecting timestamp

From: Joe Conway
Date: 28 February 2018, 02:33:46
Subject: Re: selecting timestamp