Selecting date range from database
| From: | Jeff Lewis | Date: | Wed, 26 Mar 2003 16:08:17 +0000 |
| Subject: | Selecting date range from database | ||
| References: | 1 2 3 4 5 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-141085@lists.php.net to get a copy of this message | ||
I am trying to select a date range in this format from a database 1-Mar-03
to 26-Mar-03. The date is stored in a mySQL database in that format and when
doing a normal select it just selects the dates as if they are numbers.
How can I make this select work the way I want it to work? I am using the
following query:
"SELECT * FROM members WHERE member_date >= '01-Mar-03' AND member_date <=
'26-Mar-03' ORDER BY member_date";
Jeff