Skip to content Skip to sidebar Skip to footer

Calculate Date From The Difference In Weeks

Example today's @date = 2010-02-22 14:17:19.393 Number @weeks = 2 Equation I am looking for is (@date - @weeks = 2010-02-08 14:17:19.393)

Solution 1:

select dateadd(week, @weeks*-1, @date)

Post a Comment for "Calculate Date From The Difference In Weeks"