This evening I was trying to select entries within a specific date range, for example, all torrents for films which had been released in 2007. My query looked something like:
1
SELECT name FROM TABLE WHERE date > 2007-01-01 AND date < 2008-01-01
PostgreSQL consistently returned very odd results. As far as it was concerned, Transformers [...]
