View Full Version : Date query help

03-29-2007, 09:43 PM
Hello. I want to do the following. I have a table with a date field and i want to have a select query that will show the records of the last 10 days. How can i do this?


03-30-2007, 12:18 AM
you will need to use DATE_SUB. A handy thing to remember is when you want to manipulate dates there is a date and time functions area of the manual.