Archives of the TeradataForum

Message Posted: Mon, 17 May 2010 @ 14:47:29 GMT

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

Ok, once again, try

     select case when SBMTD_DTM is null
                 then TIMESTAMP '9999-12-31 00:00:00.000000'
                 else SBMTD_DTM
                 END

      from table_1
     ;

Dave

David W. Roth
Teradata Certified Master
TERADATA

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