Bug #30796 Timestamp comparison in invalid date format
Submitted: 4 Sep 2007 14:18 Modified: 4 Oct 2007 14:47
Reporter: Marco Novo Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server: General Severity:S3 (Non-critical)
Version:5.0.22 OS:Linux
Assigned to: CPU Architecture:Any
Tags: <, comparison, invalid date format, timestamp

[4 Sep 2007 14:18] Marco Novo
Description:
I have a problem with an installation of MySQL

# Server version: 5.0.22
# Protocol version: 10
# Server: Localhost via UNIX socket

and a query like this:

SELECT * FROM table
WHERE
date1 >= '2007-08-01 00:00:00'
AND
date1 <= '2007-09-31 00:00:00'

The second date 2007-09-31 00:00:00 is obviously not valid 31 September (out of 30).

But this query WORK! in my previous installation of MySQL
# Server version: 4.1.12
# Protocol version: 10
# Server: Localhost via UNIX socket

I try to use ALLOW_INVALID_DATES but it seems not to work.

Some ideas or helps?

How to repeat:
SELECT * FROM table
WHERE
date1 >= '2007-08-01 00:00:00'
AND
date1 <= '2007-09-31 00:00:00'
[4 Sep 2007 14:47] MySQL Verification Team
Thank you for the bug report. Your server version is pretty older, could
you please test with the latest released version 5.0.45 and comment here
the results. Thanks in advance.
[4 Oct 2007 23:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".