Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 07 May 2003 @ 20:44:05 GMT


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


Subj:   Re: TimeStamp and Coalesce in V2R5
 
From:   Anomy Anom

<-- Anonymously Posted: Wednesday, May 07, 2003 15:04 -->

Hello Ganga,

I tried "CREATE TABLE T (I TIMESTAMP)" but the default precision is 6. In any case creating the table without precision and then querying it still gave me that error message.

I use Teradata SQL Assistant 6.1, The session mode in ODBC DSN is ANSI and Date format is 'AAA'. The strange thing is it works fine if the column is DATE and I use current_date in the SELECT clause as below

CREATE TABLE T ( I DATE)
SELECT COALESCE(I, CURRENT_DATE) FROM T

Thoughts?



     
  <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