Archives of the TeradataForum
Message Posted: Mon, 17 May 2010 @ 14:26:07 GMT
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.
Prasad K K
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|