Hello, i build one query in my mysql: mysql> select timestamp from lastauth where month(from_unixtime(timestamp) = 6); Empty set (0.00 sec) Query is empty, but: my timestamp table: +------------+ | timestamp | +------------+ | 1056981323 | +------------+ 1 row in set (0.00 sec) mysql> select from_unixtime(1056981323); +---------------------------+ | from_unixtime(1056981323) | +---------------------------+ | 2003-06-30 16:55:23 | +---------------------------+ 1 row in set (0.01 sec) and: mysql> select month(from_unixtime(1056981323)); +----------------------------------+ | month(from_unixtime(1056981323)) | +----------------------------------+ | 6 | +----------------------------------+ 1 row in set (0.00 sec)
Any body know where is my mistake? Regards, Condor ___________________________________ Vereya Cabel, http://www.vcable.net -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
