Archives of the TeradataForum

Message Posted: Wed, 07 May 2003 @ 21:05:28 GMT

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

Easy. Please execute the query in the following way and let me know...

SELECT COALESCE(I, CAST(CURRENT_TIMESTAMP AS TIMESTAMP(6))) FROM T

Also make sure that the data-type for 'I' is TIMESTAMP(6) when displayed using the SHOW TABLE command.

Ganga Palakattil

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