[RESOLVED] Query Question

FatStratCat

How do I incorporate a date range in a query?

Say for example I want to print all records with a due date between May 1 and May 31 2006, or as an alternate all records with a due dat eafter May 1 2006?

Select * FROM MyOrderTable WHERE DateDue >= 05/01/2206 AND DateDue <=05/31/2006

is that the correct format?

goldlikesnow

what database are you using?

FatStratCat

oh sorry. MYSQL

kburger

SELECT * FROM MyOrderTable WHERE DateDue >= '2006-05-01' AND DateDue <= '2006-05-31'

Lots of other ways, too. Check the MySQL manual.

FatStratCat

can't read that. the box is so small I can't see the print

kburger

Copy and paste, maybe? Here it is:

SELECT * FROM MyOrderTable WHERE DateDue >= '2006-05-01' AND DateDue <= '2006-05-31'

mberman

kburger wrote:
SELECT * FROM MyOrderTable WHERE DateDue >= '2006-05-01' AND DateDue <= '2006-05-31'
Lots of other ways, too. Check the MySQL manual.

http://dev.mysql.com/doc/refman/5.0/en/select.html

That's the MySQL manual page for the select function. The MySQL manual is often helpful, but sometimes it's hit-or-miss. This page doesn't seem to be too useful for your purposes.

http://dev.mysql.com/doc/refman/5.0/en/date-calculations.html

That may be useful at some point, though.

kburger

I'd have to agree about the MySQL manual quite often being less than completely helpful. But sometimes the user comments provide the help you're looking for. And here's probably a better link for this particular problem. Searching for 'date range' in the MySQL manual might turn up even better results.

http://dev.mysql.com/doc/refman/4.1/en/date-calculations.html

Edit: Looks like you found basically the same page when you edited your post. 😉

mberman

kburger wrote:
I'd have to agree about the MySQL manual quite often being less than completely helpful. But sometimes the user comments provide the help you're looking for. And here's probably a better link for this particular problem. Searching for 'date range' in the MySQL manual might turn up even better results.

http://dev.mysql.com/doc/refman/4.1/en/date-calculations.html

Edit: Looks like you found basically the same page when you edited your post. 😉

Yep, sorry I forgot to mark it as an edit 😛 You know, they say "great minds think alike" 😉

FatStratCat

thanks, that's what I was looking for