add 12 weeks to date

Question

I want to add 12 weeks to the date column as below using sql query

If dateSt has value Feb 04, 2021 the DateEd should be April 29, 2021
If dateSt has value Feb 14, 2021 the DateEd should be May 09, 2021
If dateSt has value Feb 26, 2021 the DateEd should be May 21, 2021

Answer 1

Hi @Neil ,

Please try:

    CREATE TABLE #test(dateSt date)  
    INSERT INTO #test values('20210204'),('20210214'),('20210226')  
      
    SELECT dateSt,dateadd(week,12,dateSt) as DateEd  
    FROM #test  

Output:

    dateSt DateEd  
    2021-02-04 2021-04-29  
    2021-02-14 2021-05-09  
    2021-02-26 2021-05-21  

If you have any question, please feel free to let me know.

Regards
Echo

---

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Select dateadd(day, 12*7, '20210204')
     , dateadd(day, 12*7, '20210214')
     , dateadd(day, 12*7, '20210226');

This?

Answer 3

Thanks Jeffrey and Liu, both the solution looks good

Answer 4

I tried this first
SELECT dateSt,dateadd(week,12,dateSt) as DateEd

and it is working as expected.

I sampled the result of other soln as well, I am getting the same results for both the solution. However, I implemented dateadd(week,12,dateSt) as DateEd, considering the simplicity.

But yes this solution is also working as expected and thank you for the solution.
Select dateadd(day, 12*7, '2021-02-05')

Answer 5

The solution using days was really just to show a different method - and to also show that dateadd(week is really just 'dateadd(day, 7 * #weeks'.