-10 00:00:00" AND
date_field < DATE_ADD("2003-10-10 00:00:00", INTERVAL 1 DAY);
-JF
> -Original Message-
> From: Terence [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, September 09, 2003 8:21 PM
> To: [EMAIL PROTECTED]
> Subject: MySQL 4.1 Date Comparing
>
>
&
Dear All,
We recently upgraded from 3.23 to 4.1.
We used to use queries such as:
SELECT field FROM table WHERE date_field like '2003-10-10%'
(The date_field is a "datetime" field)
Since we found the performance quicker than using the date functions.
However this no longer works in 4.1, and th