mysql - SQL查询每日属性报错

Question

我正在尝试构建一个应用程序，它使用 between 语句每天和每月逐步搜索所有属性。每日查询运行，但每月不运行。

代码:

 if (libs.conn.con.State == ConnectionState.Closed) libs.conn.baglanti.Open();
     string today = "select getdate()";
  SqlCommand today1 = new SqlCommand(today, libs.conn.con);
    string today2 = today1.ExecuteScalar().ToString();
    string[] day = today2.Split(' ');
     day[0] += " 00:00:00";
      string dayy = (DateTime.Now.Day).ToString();
       string month = (DateTime.Now.Month).ToString();
  string year = (DateTime.Now.Year).ToString();
    string[] combine = new string[] { "1." };
        combine[0] += month + ".";
           combine[0] += year + " ";
       combine[0] += "00:00:00";
       string totalmonth = "(SELECT SUM(para) FROM statistics where datee between            '"+combine[0]+"' AND '"+today2+"')";
     SqlCommand totalmoneymonthlyquery = new SqlCommand(totalmoneymonth,                 libs.conn.baglanti);
     string totalmoneymonthlyresult = totalmoneymonthlyquery.ExecuteScalar().ToString();
            textBox7.Text = totalmoneymonthlyresult.ToString();

Answer 1

使用

 combine[0]=today2

先用

拉取数据可能会出现参数错误

String.Format("{0:d/M/yyyy HH:mm:ss}", dt); 
String.Format("{0:d/M/yyyy HH:mm:ss}", dt);