Archives of the TeradataForum

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

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

Try this way,

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

thanks,

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