0

Look at the pic. How it even possible? How to avoid this?

I've no records with StartDate>='2013123-12-1' enter image description here

Improve this question
2
  • 2
    How to avoid that? Use proper date formats Commented Dec 28, 2013 at 19:45
  • 1
    MySQL is fixing the date for you, and since it is invalid, it probably, but I am not 100% certain, converting it to NULL, so it is now doing StartDate >= NULL. Anyway, do you see it says 1 warning, do show warnings after your query, you will see what it did Commented Dec 28, 2013 at 19:50

1 Answer 1

Reset to default
1

Maximum year supported by MySQL is 9999.

MySQL retrieves and displays DATE values in 'YYYY-MM-DD' format. The supported range is '1000-01-01' to '9999-12-31'.

Source: http://dev.mysql.com/doc/refman/4.1/en/datetime.html :

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.