Archives of the TeradataForum
Message Posted: Thu, 17 Feb 2011 @ 20:02:01 GMT
Thank you all who answered my question.
The query now beautifully works.
I am encouraged to ask one more question inspired by your generosity. I'd like to generate a report in ONE file that contains the output of dbc.qrylog by MONTH using SQL Assistant i.e for 2010.
Should I run 12 of the below SQL with different dates or is there a command to divide the output by month?
Sel * from dbc.qrylog where CollectTimeStamp between TIMESTAMP '2010-06-01 10:10:01' and timestamp '2010-06-30 11:00:59';
Thank you for your support.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|