Archives of the TeradataForum
Message Posted: Wed, 07 May 2003 @ 18:26:57 GMT
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)
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|