Re: selecting timestamp

chris <chrisk@xxxxxxxxxxxxxxx> · Wed, 28 Feb 2018 14:15:27 -0700



    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 <chrisk@xxxxxxxxxxxxxxx> 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.