Deleting records that are 2 months old

[bjr149]

I have a table full of records with a datetime variable. I want to do maintenance on the table, and delete reocrds from that table that are 2 months old. i want to compare the field with the time the record was written
(eg. 3/20/2006 7:56:29 AM), to the current time if its more than 2 months old i want to delete the record. Thanks for the suggestions

 

[vongrunt]

delete from blah
where datecolumn < dateadd(mm, -2, getdate())

------
[small]select stuff(stuff(replicate('<P> <B> ', 14), 109, 0, '<.'), 112, 0, '/')[/small]

 

[bjr149]

ncie works great thanks,.