有错 时间那里用单引号 update wbnews set wbdate='2005-10-24 16;20;26' where wbnewsid=1201
时间中间是冒号,不是分号update wbnews set wbdate='2005-10-24 16:20:26' where wbnewsid=1201
--如果wbdate是datetime类型字段 update wbnews set wbdate="2005-10-24 16:20:26" where wbnewsid=1201 --或者 update wbnews set wbdate='2005-10-24 16:20:26' where wbnewsid=1201
update wbnews set wbdate='2005-10-24 16:20:26' where wbnewsid=1201
字符常量必须包括在单引号 (') 或双引号 (") 中。建议用单引号括住字符常量。当 QUOTED IDENTIFIER 选项设为 ON 时,有时不允许用双引号括住字符常量。
时间那里用单引号
update wbnews
set wbdate='2005-10-24 16;20;26'
where wbnewsid=1201
update wbnews set wbdate="2005-10-24 16:20:26" where wbnewsid=1201
--或者
update wbnews set wbdate='2005-10-24 16:20:26' where wbnewsid=1201
set wbdate='2005-10-24 16:20:26'
where wbnewsid=1201