Tony
Tony

Reputation: 3805

MySQL Select statement trouble

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

Upvotes: 0

Views: 49

Answers (1)

Vinicius Braz Pinto
Vinicius Braz Pinto

Reputation: 8289

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 :

Upvotes: 1

Related Questions