Archives of the TeradataForum

Message Posted: Wed, 07 May 2003 @ 18:26:57 GMT

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

Execute the following as a SQL statement before issueing the SELECT.

SET SESSION DATEFORM=ANSIDATE;

Make sure that the 'I' datatype is Timestamp by using SHOW TABLE command. If not, run the CREATE statement using BTEQ.

You need to say TIMESTAMP and CURRENT_TIMESTAMP straight away instead of suffixing with (6)

-Ganga Palakattil

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