I have a SQL table where I need to delete records. I need to delete all the records accept todays records. The table have around 800,000 records. The table has the following fields.
ID, Curr, Bid, LastUpdate, Offer.
The LastUpdate field is the one with the dates which is in this format 28 Oct 2003 10:52
How will I go about to delete the records older than today.