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:[EMAIL PROTECTED]> . 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.
-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
