Re: ms sql - delete records where older than 6 months

2006-02-02 Thread Protoculture
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

RE: ms sql - delete records where older than 6 months

2006-02-02 Thread Adrian Lynch
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

RE: ms sql - delete records where older than 6 months

2006-02-02 Thread DURETTE, STEVEN J \(AIT\)
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.

ms sql - delete records where older than 6 months

2006-02-02 Thread Protoculture
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