我想更新3小时之前发表的记录进行更新,下面的语句不对!不执行,高手帮忙改正!
conn.execute( "update title set ifzd=0 where ifgg=1 and datediff( 'h ',addtime,date()) <=3 ")
------解决方案--------------------
conn.execute( "update title set ifzd=0 where ifgg=1 and datediff(h,addtime,date()) <=3 ")