Re: selecting timestamp

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 >wrote:

Re: selecting timestamp

On 02/27/2018 12:16 PM, chris wrote: > > 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 c

Re: selecting timestamp

On Tue, Feb 27, 2018 at 1:16 PM, chris 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 conformi

Re: selecting timestamp

On 02/27/2018 12:16 PM, chris wrote: What is the best way of selecting current timestamp in UTC? SELECT CURRENT_TIMESTAMP   as ct1 Well the above would depend on your database having its time zone set to UTC. ,timezone('UTC',CURRENT_TIMESTAMP) as ct2 ,timezone('utc',now()) as ct3 ,CURRENT_T

selecting timestamp

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