...

View Full Version : Date query help



vasilanthropos
03-29-2007, 08: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?

Thanks

guelphdad
03-29-2007, 11:18 PM
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.



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum