Earlier this week, I thought I had made a crucial mistake when I was testing a couple of new and existing reports on my Debian database server (at home). For some kind of reason, firing up a query that returns a selection between two dates didn’t return the results I wanted to see (example):
SELECT * from atable
WHERE date_in >= '01/01/05'
AND date_in < = '01/31/05';
Under all normal circumstances this query should return all the rows that fall in between those days, including the 31st of January. My home server didn’t.
It ended up to be a timezone configuration error on my server: My server was set to EST, while AST would have been more appropriate.