MySQL gotcha using BETWEEN with dates

Friday, 16 November 2007, 12:47 | Category : MySQL, Software Development
Tags :

We just updated a development server from Ubuntu 6.06 to 6.10. As a result, MySQL went up a couple of point releases from 5.0.22 to 5.0.24a.
Suddenly, the web application we were working on stopped working. It wasn’t possible to log in.
We quickly narrowed it down to a clause in query which checked a users subscription [...]