34,837
社区成员




CREATE TABLE wf2091139
(
DTIME VARCHAR(20)
)
DELETE wf2091139
INSERT INTO wf2091139
SELECT '1906-12-23 '
SELECT * FROM wf2091139
UPDATE wf2091139 SET DTIME = DATEADD(YY,100,DTIME)
update table
set col = dateadd(yy,100,col)
update table
set col = datedd(yy,100,col)
update table
set col = datadd(yy,100,col)