Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 29 Jun 2006 @ 23:22:19 GMT


     
  <Prev Next>  
<<First
<Prev
Next> Last>>  


Subj:   TIMESTAMP with TIMEZONE
 
From:   Anomy Anom

<-- Anonymously Posted: Thursday, June 29, 2006 18:14 -->

We have loaded a transaction table with a column defined with a TIMESTAMP data type with GMT data and a location_id. Now we need to display each time in the location_id's local time. I don't see how that would be possible in the current set up, even if I know each location_id's time zone, due to daylight savings. I believe the column would have to be TIMESTAMP WITH TIMEZONE to have this functionality. That way you can display it as either GMT or local. Is there another solution?

For example:

Currently stored as:

     2006-06-29 22:49:13.000000

Should be stored as

     2006-06-29 16:49:13.000000 -06:00


     CREATE TABLE dbname.transaction_log
          (
           TRAN_TS TIMESTAMP(6) NOT NULL,
           LOCATION_ID SMALLINT NOT NULL
          )
     ;


     
  <Prev Next>  
<<First
<Prev
Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023