great, guys thanks.
Forgot I could use DateAdd to actually subtract.
~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231088
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.house
Something like:
WHERE DATEDIFF(m, date_set) > 5
Test the boundary cases though, dates can get you in trouble :O)
Ade
-Original Message-
From: Protoculture [mailto:[EMAIL PROTECTED]
Sent: 02 February 2006 11:13
To: CF-Talk
Subject: ms sql - delete records where older than 6 months
How
Delete from mytable_fav_cvs
Where date_set < dateAdd(m, -6, getDate())
SHOULD delete every thing that is before 6 months from today.
-Original Message-
From: Protoculture [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 02, 2006 6:13 AM
To: CF-Talk
Subject: ms sql - delete records wh
3 matches
Mail list logo