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
rds where older than 6 months
How would I finish the following sql statement to delete all records
older than 6 months?
delete * from mytable_fav_cvs
where date_set
...
cheers
~|
Message: http://www.houseoffusion.
How would I finish the following sql statement to delete all records older than
6 months?
delete * from mytable_fav_cvs
where date_set
..
cheers
~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231084
Archives
4 matches
Mail list logo