สอบถามหน่อยครับเรื่องการเพิ่ม insert วันที่เข้าไปใน Database

private void save_data_Click(object sender, EventArgs e)
        {
            string StrQuery;
            using (SqlConnection conn = new SqlConnection(connecting))
            {
                using (SqlCommand comm = new SqlCommand())
                {
                    comm.Connection = conn;
                    conn.Open();
                    for (int i = 0; i < dataGridView1.Rows.Count-1; i++)
                    {
                        StrQuery = @"INSERT INTO short_data_pm (PARTNAME, CODE, STEP, PROCESS,TOTAL_LAST,TOTAL_CURRENT,LENGTH_ALERT,SUM_TOTAL,CREATE_DATE) 
                        VALUES ('" + dataGridView1.Rows[i].Cells[1].Value + "','" + dataGridView1.Rows[i].Cells[2].Value + "', '" + dataGridView1.Rows[i].Cells[3].Value + "', '" + dataGridView1.Rows[i].Cells[4].Value + "', '" + 
                        dataGridView1.Rows[i].Cells[5].Value + "', '" + dataGridView1.Rows[i].Cells[6].Value + "', '" + dataGridView1.Rows[i].Cells[7].Value + "', '" + dataGridView1.Rows[i].Cells[8].Value + "', '" + dataGridView1.Rows[i].Cells[9].Value +"',GETDATE());";
                        comm.CommandText = StrQuery;
                        comm.ExecuteNonQuery();
                    }
                    conn.Close();
                }
            }
}