Archives of the TeradataForum

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

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

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