2012. 10. 26. 14:21
declare
@StartDate datetime = '2010-01-25',
@EndDate datetime = '2010-02-05'
select GETDATE()
select dateadd(day, 10, @StartDate), dateadd(day, -10, @StartDate)
select datediff(day, @StartDate, @EndDate), datediff(month, @StartDate, @EndDate)
select datepart(year,@StartDate), datepart(month,@StartDate) ,datepart(day,@StartDate)
select year(@StartDate), month(@StartDate), day(@StartDate)