Hi All,

Check this it will work:

select * from CounterData

where

CONVERT(datetime,CONVERT(char(23),CounterDateTime),121)>dateadd(mi,-60,getdate())

Thanks,

Fouzan