キャスト関数CAST()関数SELECT CAST(1-2 AS UNSIGNED) 参考http://dev.mysql.com/doc/refman/5.1/ja/cast-functions.html DateTimeのキャストキャストしても望んだ結果にならないので、DATE()関数を使う。 mysql> SELECT DATE '2010-01-01 10:00:00' = DATE '2010-01-01' AS ret; +-----+ | ret | +-----+ | 0 | +-----+ mysql> SELECT DATE('2010-01-01 10:00:00') = DATE '2010-01-01' AS ret; +------+ | ret | +------+ | 1 | +------+ 参考http://dev.mysql.com/doc/refman/5.1/ja/date-and-time-functions.html |
|