当数据库中记录的时间精确为毫秒时,对于编程的调用会产生一些影响,下面在尽量不影响数据使用的情况下将毫秒级数据更新为
原时间去除毫秒后的时间
- UPDATE JSERP.U_JSNR SET u_jsnr_whsj = Convert(datetime,convert(char(100),b.u_jsnr_whsj,120))
- from jserp.u_jsnr b where U_JSNR_XMID = b.U_JSNR_XMID
- and U_JSNR_DJID = b.U_JSNR_DJID
- and U_JSNR_DJXH = b.U_JSNR_DJXH
- and U_JSNR_YEAR = b.U_JSNR_YEAR
- and U_JSNR_MONTH = b.U_JSNR_MONTH
- and U_JSNR_TXY = b.U_JSNR_TXY
- and U_JSNR_XH = b.U_JSNR_XH