I want to call get date function with field modifieddatetime in a stored procedure

See more:

SQL-Server-2008R2

this is a stored procedure which i created


ALTER PROCEDURE [dbo].[UpdateInDegrees]
-- Add the parameters for the stored procedure here
@ID int output,@Name nvarchar(100),@Code nvarchar(10)
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
Declare @ModifiedDateTime Datetime
SET NOCOUNT ON;

Set @ModifiedDateTime = getdate()
-- Insert statements for procedure here
Update Degrees set Name=Upper(@Name),Code=Upper(@Code) where ID=@ID
END



this is a function where i call this stored procedure

public void UpdateInDegrees(TextBox _txtdgname, TextBox _txtdgcode, Label _lbldgID)
{

cm = new SqlCommand();
cm.Connection = cn;
cm.CommandType = CommandType.StoredProcedure;
cm.CommandText = "UpdateInDegrees";
cm.Parameters.AddWithValue("@Name", _txtdgname.Text);
cm.Parameters.AddWithValue("@Code", _txtdgcode.Text);
cm.Parameters.AddWithValue("@ID", _lbldgID.Text);
cm.ExecuteNonQuery();
}

What I have tried:

ALTER PROCEDURE [dbo].[UpdateInDegrees]
-- Add the parameters for the stored procedure here
@ID int output,@Name nvarchar(100),@Code nvarchar(10)
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
Declare @ModifiedDateTime Datetime
SET NOCOUNT ON;

Set @ModifiedDateTime = getdate()
-- Insert statements for procedure here
Update Degrees set Name=Upper(@Name),Code=Upper(@Code) where ID=@ID
END