Archives of the TeradataForum

Message Posted: Wed, 07 May 2003 @ 20:57:29 GMT

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

Try this way,

sel coalesce(I, cast(current_timestamp(6) as timestamp(6))) from T;

thanks,

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