I have just started noticing some bizarre behaivor in tables in our database that contain a TIMESTAMP(14) field.
I only shown a small query, but it highlights the error: mysql> SELECT ErrorTime FROM ErrorLog WHERE ErrorTime = 20031210063712; +----------------+ | ErrorTime | +----------------+ | 20031211063712 | +----------------+ 1 row in set (0.51 sec) mysql> SELECT ErrorTime FROM ErrorLog WHERE ErrorTime = 20031211063712; Empty set (0.54 sec) Why am I getting back 11-Dec dates when I requested the 10th? Here's the table defn: CREATE TABLE `ErrorLog` ( `ID` int(11) NOT NULL auto_increment, `Code` varchar(5) default NULL, `Severity` varchar(15) default NULL, `Text` text, `ErrorTime` timestamp(14) NOT NULL, `Component` varchar(50) default NULL, `Object` varchar(255) default NULL, `Hostname` varchar(255) default NULL, PRIMARY KEY (`ID`) ) TYPE=MyISAM MAX_ROWS=4294967295 AVG_ROW_LENGTH=120 Thanx in advance for any help, Regards, Matthew. ____________________________________________________________________________ Matthew M. Boulter Software Engineer Saab ITS Pty Ltd Mobile: +61 (0)415 169 088 Phone: +61 (0)7 3854-4815 Fax: +61 (0)7 3854-4899 Email: [EMAIL PROTECTED] WWW: www.saab-its.com.au -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
