是的,但是具体怎么改,能否说一下 如果一条条改倒是可能改得过来,但是数据太多了,也不知道改到何年马月UPDATE Resume1 SET Res_WOver = '"&split(Res_WOver," ")(2)&"-"&split(Res_WOver," ")(1)&"-"&split(Res_WOver," ")(0)&"' WHERE (Res_Id = Res_Id) AND (Res_WOver IS NOT NULL)我这样试过了,但是弹出如下错误[Microsoft][ODBC SQL Server Driver][SQL Server]将截断字符串载二进制数据
因为smalldatatime的存储格式是固定的,所以,只要修改字段类型成功,那就行了.查询的时候可以用convert来指定显示格式
如果一条条改倒是可能改得过来,但是数据太多了,也不知道改到何年马月UPDATE Resume1
SET Res_WOver = '"&split(Res_WOver," ")(2)&"-"&split(Res_WOver," ")(1)&"-"&split(Res_WOver," ")(0)&"'
WHERE (Res_Id = Res_Id) AND (Res_WOver IS NOT NULL)我这样试过了,但是弹出如下错误[Microsoft][ODBC SQL Server Driver][SQL Server]将截断字符串载二进制数据