Re: MySQL query
| From: | Richard Davey | Date: | Mon, 12 Jan 2004 20:29:12 +0000 |
| Subject: | Re: MySQL query | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-174366@lists.php.net to get a copy of this message | ||
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:rich@launchcode.co.uk