Using datetime parameters in a stored procedure SQL Server 2012

Question

I'm struggling with how to pass datetime parameters into a stored procedure. This is the example I'm working with. I commented out the declaring of the variables, because if I declare them it doesn't let me pass them in when I execute, but if I don't declare them, I can't execute it. Please help!

    --The Create Procedure Code
    CREATE PROCEDURE users.my_test
    AS

    --declare @startdatetime datetime = '03-20-2019'
    --declare @enddatetime datetime = '05-20-2019'
    SELECT datediff(mi,@startdatetime,@enddatetime)
    GO

    --The execution Code
    exec users.my_test
    @startdatetime = '03-31-2019', @enddatetime = '07/03/2019'
    GO

What you're doing here is defined two internal variables for the stored procedure - those are not parameters that can be set when calling the procedure! Parameters must be declared right after the stored procedure name, and with a leading @ — marc_s
– marc_s, Commented Aug 1, 2019 at 5:07

Serkan Arslan · Accepted Answer · 2019-07-31 21:04:35Z

1

You can add parameter like this

CREATE PROCEDURE users.my_test
 @startdatetime datetime ,
 @enddatetime datetime 
AS

--declare @startdatetime datetime = '03-20-2019'
--declare @enddatetime datetime = '05-20-2019'
SELECT datediff(mi,@startdatetime,@enddatetime)
GO

answered Jul 31, 2019 at 21:04

Serkan Arslan

13.4k4 gold badges33 silver badges46 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Using datetime parameters in a stored procedure SQL Server 2012

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related