Hello Ashley, Monday, January 12, 2004, 8:21:01 PM, you wrote:
AMK> What I'd like to do is search for records that are between AMK> 2004-01-09 and 2004-01-04. The time is to be ignored, just the date is AMK> what I need to search by. Is there a way to do this within an sql AMK> query, or do I have to do some PHP processing of the datetime field to AMK> get what I need? SELECT whatever FROM table WHERE date_column_name BETWEEN '2004-01-09 00:00:00' AND '2004-01-04 23:59:59' -- Best regards, Richard mailto:[EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
