Archives of the TeradataForum

Message Posted: Thu, 01 May 2003 @ 21:11:04 GMT

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

I suspect this QCD was created with (an older version of) DIPQCD script and the creating session was using ANSI date format. Check to see if it's the problem I remember:

select TableName, ColumnName, ColumnFormat
from dbc.columns where databasename = 'qcd' and columntype='da';

TableName ColumnName ColumnFormat
Query         DateTimeStamp YY/MM/DD

If you have a different ColumnFormat, that's the problem. One option would be to drop the QCD and re-create it using VE tools. Or just alter the format:

ALTER TABLE QCD.Query ADD DateTimeStamp DATE FORMAT 'YY/MM/DD';

Also, I'd recommend you explicitly specify the database name to be used for query capture:

INSERT EXPLAIN INTO qcDatabaseName AS myQueryLabel SELECT...

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