Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 17 May 2010 @ 14:26:07 GMT


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


Subj:   Re: Timestamp (6) data mismatch issue
 
From:   Prasad Kavil Kambrath

Hi all,

In my table, I have a column , "time_submtd" with data type as timestamp(6).It can have null values.

I need to do fast export from this table and since we can't specify a delimiter when we are using FEXP, I am concatenating the records using "|" as delimiter. I am using COALESCE function to convert null values from all other columns, but when I am using this function for the column " time_submtd" I am getting a data type mismatch error. I tried the following options and nothing is working for me.

     select case when SBMTD_DTM is null  then cast ('9999-12-31 00:00:00.000'
     as timestamp(6))  else SBMTD_DTM END  from table_1

     select case when SBMTD_DTM is null  then cast (current_timestamp(6) as
     timestamp(6))  else SBMTD_DTM END  from table_1

     select COALESCE(SBMTD_DTM,' ') from table_1

     select COALESCE(SBMTD_DTM,0) from table_1

     select COALESCE(SBMTD_DTM,'') from table_1

Please help me.

Thanks,

Prasad K K
Senior Software Engineer



     
  <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