Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 18 Oct 2010 @ 19:58:55 GMT


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


Subj:   Defaulting TIMEZONE value while Creating/loading
 
From:   Gajula, Madhu

Hello,

Thanks in advance for the knowledge you guys are sharing.

I am trying to Create AND INSERT a default value of timestamp with timezone into a DATE columns defined as below. I am not able to get it to work. Any help is appreciated

     create table t1(
     record_end_dtm TIMESTAMP(6) with TIME ZONE FORMAT 'YYYY-MM-DDBHH:MI:SS.S(6)BZ ' NOT NULL
     DEFAULT Timestamp '9999-12-31 11:59:00' )

This above create works ..

I was wondering if we can create with the time zone literal too. like using the DDL statements as below (both are not working) create table t1 (record_end_dtm TIMESTAMP(6) with TIME ZONE FORMAT 'YYYY-MM-DDBHH:MI:SS.S(6)BZ ' NOT NULL DEFAULT Timestamp '9999-12-31 11:59:00.000000 6' )

or

     create table DW_STAGING.t1
     (record_end_dtm TIMESTAMP(6) with TIME ZONE FORMAT 'YYYY-MM-DDBHH:MI:SS.S(6)BZ ' NOT NULL
     DEFAULT Timestamp with time zone
     '9999-12-31 11:59:00.000000 +00:00' )

AND I am also trying to insert a timestamp and timezone as a literal like below which gives invalid Timestamp error.

     insert into t2 values (   '9998-12-31 11:59.00.000000 6'  )
     insert into t2 values (   '9998-12-31 11:59.00.000000 00:00'  )

I am not sure if I am missing any information on TimeZONE and how its used inTeradata.


Thank You,

MGajsk.



     
  <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: 27 Dec 2016