Archives of the TeradataForum

Message Posted: Thu, 17 Feb 2011 @ 15:40:43 GMT

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

Dear users,

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;

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