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 How

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

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