in reply to DBI and TIMESTAMP

Assuming that you are using a mySQL database, have a look at the "6.2.2.2 The DATETIME, DATE, and TIMESTAMP Types"-section in the documentation. It explains all about these formats.

Just guessing, but I think you are looking at the display format of the field, whereas you would rather test the internal value.

CountZero

"If you have four groups working on a compiler, you'll get a 4-pass compiler." - Conway's Law