Bug #22058 BETWEEN command problem
Submitted: 6 Sep 2006 17:02 Modified: 6 Sep 2006 20:01
Reporter: bayu as Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:4.1.21 OS:Linux (CENTOS 4.4)
Assigned to: CPU Architecture:Any
Tags: BETWEEN date1 AND date2

[6 Sep 2006 17:02] bayu as 
Description:
This query command under 4.1.20 was working:
select count(*) from table where NOW() between start and end;

** "start" & "end" are table field (as DATE format)

After upgrade 4.1.21 that query is not working, with zero result.

using the following command: SELECT count( * ) FROM table WHERE NOW( ) > start  AND NOW( ) < end;   it works under 4.1.21

how to solve.

How to repeat:
select count(*) from table where NOW() between start and end;

** "start" & "end" are table field (as DATE format)

under 4.1.21 is not working.
[6 Sep 2006 20:01] Sveta Smirnova 
Please do not submit the same bug more than once. An existing bug report already describes this very problem. Even if you feel that your issue is somewhat different, the resolution is likely
to be the same. Because of this, we hope you add your comments to the original bug instead.

Thank you for your interest in MySQL.

Duplicates bug #21677