[SOLVED] Quick question regarding deletion of certain dates

[waynew]

I've been asked to get rid of old orders after a certain time period. Column in question uses datetime. i.e 2008-11-20 09:00:00

 

How could I delete everything that comes before that certain date.

 

Would it be:

 

WHERE orderDate < '2008-11-20 09:00:00'

 

Or

 

WHERE orderDate > '2008-11-20 09:00:00'

 

 

 

[premiso]

WHERE orderDate < '2008-11-20 09:00:00'

 

Less than the specific date for older greater than specific date for newer.

 

I would also setup a test DB to test this out if you are afraid of wiping the wrong data, that way you know it works.

[.josh]

2nd one.  We move forward in time, so anything you want removed before now (or whenever) would be less than now (or whenever)

[gevans]

You could run a test first,

 

use SELECT instead of DELETE through phpMyAdmin, then you'll see all the rows that you will be deleting

 

(but the guys are right, you want less than)

[waynew]

Thought so. Just figured I'd get a second opinion before I went waltzing in there deleting orders! Thanks!