MySQL query
| From: | Ashley M. Kirchner | Date: | Mon, 12 Jan 2004 20:21:01 +0000 |
| Subject: | MySQL query | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-174365@lists.php.net to get a copy of this message | ||
I need to query for record within a certain date stamp. The datetime field contains the createdon information that i need and is in the following format: 2004-01-11 21:40:50
What I'd like to do is search for records that are between 2004-01-09 and 2004-01-04. The time is to be ignored, just the date is what I need to search by. Is there a way to do this within an sql query, or do I have to do some PHP processing of the datetime field to get what I need?
--
W | I haven't lost my mind; it's backed up on tape somewhere.
+--------------------------------------------------------------------
Ashley M. Kirchner <mailto:ashley@pcraft.com> .
303.442.6410 x130
IT Director / SysAdmin / WebSmith . 800.441.3873 x130
Photo Craft Laboratories, Inc. . 3550 Arapahoe Ave. #6
http://www.pcraft.com ..... . . . Boulder, CO 80303,
U.S.A.