where to_char(Indate,'yyyy-mm-dd') =to_char(sysdate,'yyyy-mm-dd') 精确到日
谢谢啊,可是不行啊 提示信息MySQL 返回: #1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '( Indate , 'yyyy-mm-dd' ) = to_char ( sysdate , 'yyyy-mm-dd' )
提示信息MySQL 返回: #1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '( Indate , 'yyyy-mm-dd' ) = to_char ( sysdate , 'yyyy-mm-dd' )
用CURDATE()得到当前日期,2007-6-6