Code for Datetime.Now as parameter

string query = "select * from appointments where start_date = @startdate";
SqlCommand cmd = new SqlCommand();
cmd.CommandText = query;
cmd.Parameters.Add ("@startdate", SqlDbType.DateTime);
cmd.Parameters["@startdate"].Value = DateTime.Now