simple sql question
| From: | Paulson, Joseph V. \"Jay\" | Date: | Wed, 28 Mar 2001 00:49:36 +0000 |
| Subject: | simple sql question | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-7915@lists.php.net to get a copy of this message | ||
Hello-
I'm running MySQL and php and when I run the query below I don't get any
return rows. As you can see I search for events that are happening between
a certain date. The "startDate" field is type DATE in MySQL and the date in
the database that should be returned in "2001-03-27" but I'm not getting any
results.
select * from events where startDate>='2001-03-01' and
startDate<'2001-01-04'
Any help on what I could be doing wrong would be great!
Thanks,
Jay Paulson
Developer, Web Technologies
Viatel, Inc.
http://www.viatel.com