update test SET 字段名 = (字段名 + interval '3 D')
ps: + interval '3 D' 是+3天的意思,interval 可以不写
Y Years
M Months (in the date part)
W Weeks
D Days
H Hours
M Minutes (in the time part)
S Seconds
update test SET 字段名 = (字段名 + interval '3 D')
ps: + interval '3 D' 是+3天的意思,interval 可以不写
Y Years
M Months (in the date part)
W Weeks
D Days
H Hours
M Minutes (in the time part)
S Seconds