SQL Server 2005: how to subtract 6 month

Viewed 79910

I have a date, suppose today date

declare @d datetime
set @d = '20101014'

I need

select @d - <six month>

where is the real number of days that contains last six month, beginning from @d.

2 Answers
Related