In your homenode you say that you have Paul Dubois's books (MySQL and MySQL and Perl for the web)

Both books explain in great detail how MySQL deals with TIMESTAMP fields.

Don't be shy. Take those books out of your shelves and actually read them.