Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 19 Oct 2010 @ 09:03:16 GMT


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


Subj:   Re: Defaulting TIMEZONE value while Creating/loading
 
From:   DWellman

Hi,

The insert is failing because your literals are not formatted correctly.

As per the SQL Reference Data Types and Literals manual, Timestamp with time zone literals in Teradata have to:

- start with the word TIMESTAMP

- have colons (:) after the hour and minute values

- have a leading sign (either + or -)

- use 2 digits for hours and 2 digits for minutes.


So try:

     insert into t2 values (TIMESTAMP   '9998-12-31 11:59:00.000000+06:00'  )
     insert into t2 values (TIMESTAMP   '9998-12-31 11:59:00.000000+00:00'  )

Cheers,

Dave

Ward Analytics Ltd - Information in motion ( www.ward-analytics.com )



     
  <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