Hello. I have a problem where TIMESTAMP comparison fails on MySQL 3.23.52 on RedHat 7.3.
I have installed the RPMS that came with the distro as well as the ones from the mysql.com site. The results are the same: mysql> select TIMESTAMP from tblPositions; +----------------+ | TIMESTAMP | +----------------+ | 20020903143248 | +----------------+ 31 rows in set (0.00 sec) mysql> select TIMESTAMP from tblPositions WHERE TIMESTAMP=20020903143248; Empty set (0.00 sec) I have seen this before when I built a copy on a RH 6.2 box. Installing the binaries made it go away. RH 7.2 seems to work okay with the binaries. This is a problem, especially when using MyODBC- which uses the timestamp for finding the appropriate rows. Any suggestions? -- Ram Rajadhyaksha Inflection Technology, LLC www.inflectiontech.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
