convert anonymous block to a stored procedure that will accept a date as input a

Question

convert anonymous block to a stored procedure that will accept a date as input and print the original date, the date after one year, week and day. Execute your stored procedure. Examples of execution.

Code:

DECLARE @date DATETIME

SET @date= getdate(); -- set @date as current date

SELECT @date as 'Current Date', -- display current date

       DATEADD(year, 1, @date) AS 'Plus one Year',

       DATEADD(week, 1, @date)   AS 'Plus one week',

       DATEADD(day, 1, @date) AS 'Plus one Day';

Sample output:

E declare Ma datetime SET getdate() exec date procedure Ma SET la CAST( 10-JAN-2017 as datetime); exec date procedure Ma 100% Messages original date Jan 12 2015 4:47PM A year later Jan 12 2016 4:47P A week later Jan 19 2015 4:47PM A day later Jan 13 2015 4:47PM original date Jan 10 2017 12:00AM A year later Jan 10 2018 12:00AM A week later Jan 17 2017 12:00AM A day later Jan 11 2017 12:00

Explanation / Answer

create procedure dates @startdate smalldatetime Set @dateafteryear= DATEADD(YYYY,1, @startdate) Set @weekafter= DATEADD(week,1, @startdate) Set @daylater= DATEADD(day,1, @startdate) print 'Original Date'; print @startdate ; print 'A Year later'; print @dateafteryear; print 'A week later'; print @weekafter; print 'A day later'; print @daylater;

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.