Archives of the TeradataForum

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

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

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