"Matthew Boulter" <[EMAIL PROTECTED]> wrote: > > I have just started noticing some bizarre behaivor in tables in our = > database that contain a=20 > TIMESTAMP(14) field.=20 > > I only shown a small query, but it highlights the error: > > mysql> SELECT ErrorTime FROM ErrorLog WHERE ErrorTime =3D = > 20031210063712; > +----------------+ > | ErrorTime | > +----------------+ > | 20031211063712 | > +----------------+ > 1 row in set (0.51 sec) > > mysql> SELECT ErrorTime FROM ErrorLog WHERE ErrorTime =3D = > 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=3DMyISAM MAX_ROWS=3D4294967295 AVG_ROW_LENGTH=3D120 >
Check if the table is Ok with CHECK TABLE statement or with myisamchk. If so, create repeatable test case, I wasn't able to repeat the above behaviour with my test data. What version of MySQL do you use and which OS? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
