[EMAIL PROTECTED] wrote:
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
Move the parenthesis:
select timestamp from lastauth where month(from_unixtime(timestamp))=6;
Regards,
Joseph Bueno
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
