SQL语句

UPDATE fp_bfzt_danweijoincun_copy_copy SET endTime=cast(endTime as datetime)
WHERE beginTime !=""

SET daozhangTime=SUBSTR(daozhangTime,1,instr(xiaboTime,' '))

原文地址:https://www.cnblogs.com/1ming/p/9682214.html