Error Conversion failed when converting date andor time from character string.
i have SP and date column type is date, i want to use current date in store procedure
i am not passing any value and i will not pass any value, i am using current date by using getdate()
Alter PROCEDURE Sp_Manual
-- Add the parameters for the stored procedure here
@StartDate date =GETDATE,
@Enddate date =GETDATE
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
-- Insert statements for procedure here
SELECT l.LocName AS Location, SUM(c.QTY) AS Expr1, SUM(c.IWeight) AS Weigth
FROM ConIssuance AS c
INNER JOIN Location AS l ON c.LocID = l.LocID
where C.EntryDate between @StartDate and @Enddate
GROUP BY c.QTY, c.IWeight, l.LocName
END
GO