here any sample for datediff function and adding days
run all script in query analyzer
Code:
declare @date1 datetime declare @date2 datetime set @date1='20070101' set @date2=getdate() --datediff returns an int select datediff(day,@date1,@date2) --adding days to date type variable only select @date1 + 30
Leave a comment: