DATEADD(datepart, number, date):Returns a new datetime value based on adding an interval to the specified date.Datepart Abbreviations year yy, yyyy quarter qq, q month mm, m dayofyear dy, y day dd, d week wk, ww hour hh minute mi, n second ss, s millisecond ms
怎么显示后三天的日期.
是这样的吗?
select dateadd(dd,3,getdate())
select dateadd(dd,+3,getdate())
或
select getdate()+3
year yy, yyyy
quarter qq, q
month mm, m
dayofyear dy, y
day dd, d
week wk, ww
hour hh
minute mi, n
second ss, s
millisecond ms