Quoting Barry <[EMAIL PROTECTED]>: > Ben Clewett schrieb: > > Hi Barry, > > > > This will happen when comparing against a TIMESTAMP field. > > > > CREATE TABLE a ( t TIMESTAMP ); > > > > SELECT * FROM a WHERE t > '0001-01-01 00:00:00'; > > > > Well my msql doesn't give me any errors using that query. > neither a warning.
Ditto. usemysql> use test; Database changed mysql> CREATE TABLE a ( t TIMESTAMP ); Query OK, 0 rows affected (0.27 sec) mysql> SELECT * FROM a WHERE t > '0001-01-01 00:00:00'; Empty set, 1 warning (0.21 sec) mysql> SELECT VERSION(); +------------+ | VERSION() | +------------+ | 5.0.21-log | +------------+ 1 row in set (0.05 sec) mysql> DROP TABLE a; Query OK, 0 rows affected (0.04 sec) mysql> -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
