Question

我试图将日期和时间储存在地板服务器上,但正出现错误。

    private void button1_Click(object sender, EventArgs e)
    {
        string d = DateTime.Now.ToShortDateString();
        string t = DateTime.Now.ToShortTimeString();
        cmd.CommandText = "insert into transaction values("+label9.Text+", "+d+" , "+t+" );";
        cmd.Connection = con;
        con.Open();
        int x= cmd.ExecuteNonQuery();
        MessageBox.Show("Attendance recorded succesfully");   
    }

http://www.ohchr.org。我将数据类型作为var仪服务器中的日期和时间领域。

Answer 1

使用[交易]而不是交易

Answer 2

private void button1_Click(object sender, EventArgs e)
    {
        string timeString = "11/12/2009 13:30:00.000";
        IFormatProvider culture = new CultureInfo("en-US", true);
        DateTime dateVal = DateTime.ParseExact(timeString, "dd/MM/yyyy HH:mm:ss.fff", culture);
        cmd.CommandText = "insert into transaction values(" + label9.Text + ", " + dateVal + " );";
        cmd.Connection = con;
        con.Open();
        int x = cmd.ExecuteNonQuery();
        MessageBox.Show("Attendance recorded successfully");
    }

Answer 3

private void button1_Click(object sender, EventArgs e)
    {
        string d = DateTime.Now.ToString("dd/MM/yyyy");
        string t = DateTime.Now.ToString("hh:mm:ss tt");
        cmd.CommandText = "insert into transaction values("+label9.Text+", "+d+" , "+t+" );";
        cmd.Connection = con;
        con.Open();
        int x= cmd.ExecuteNonQuery();
        MessageBox.Show("Attendance recorded succesfully");   
    }

第二,你也可以尝试使用KetDate(GetDate) 职能:在无错误的情况下插入日期和时间。

仅限日期:

 SELECT DATEADD(dd, 0, DATEDIFF(dd, 0, GETDATE()))

第一部分:

不得变形;和
无需考虑当地情况

时间:

SELECT LTRIM(RIGHT(CONVERT(VARCHAR(20), GETDATE(), 100), 7))

如果有人能够帮助利用“Convert”和“当地”获得时间/时间。

友情链接