Thanks Suresh.

That worked for me..

select <published_colums> From dbo.AgentQueueActivationHist where [ActivationDateTime] >= getdate() - 60

even we can do

select <published_colums> From dbo.AgentQueueActivationHist where [ActivationDateTime] >= dateadd(d, -60, getdate())

Thanks for the...