Archives of the TeradataForum
Message Posted: Thu, 17 Feb 2011 @ 15:40:43 GMT
I ran below SQL using SQL Assistant and got an error saying 'invalid timestamp'. I don't know what causes the error. I'd like to generate the report by month from dbc.qrylog table. What is the best way to do it?
Thank you in advance.
Sel * from dbc.qrylog where CollectTimeStamp between '06/01/2010 10:10:01' and '06/31/2010 11:00:59' sample 5;
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|