Joseph Bueno <[EMAIL PROTECTED]> написа :
> [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 > > > > > > > > > > Move the parenthesis: > select timestamp from lastauth where month(from_unixtime(timestamp))=6; > > Regards, > Joseph Bueno > > It's work now, thanks :) 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]