sql - 从字符串转换日期和/或时间时转换失败

Question

这段代码昨天能用，但现在不行了。我没有改变任何东西...为什么会这样，我该如何解决？

    {
        var info = TimeZoneInfo.FindSystemTimeZoneById("Turkey Standard Time");
        DateTimeOffset localServerTime = DateTimeOffset.Now;
        DateTimeOffset istanbulTime = TimeZoneInfo.ConvertTime(localServerTime, info);

        con.Open();
        cmd.CommandText = "UPDATE BilgisayarDuyuru SET date='" + istanbulTime + "'  WHERE id='" + id + "'";
        cmd.ExecuteNonQuery();
        con.Close();            
    }

Answer 1

好的，试试这个

{
 var info = TimeZoneInfo.FindSystemTimeZoneById("Turkey Standard Time");
 DateTimeOffset localServerTime = DateTimeOffset.Now;
 DateTimeOffset istanbulTime = TimeZoneInfo.ConvertTime(localServerTime, info);
string s1 = istanbulTime.ToString("yyyy-MM-dd HH:mm:ss.ffffff zzz");
con.Open();
cmd.CommandText = "UPDATE BilgisayarDuyuru SET date='" + s1+ "'  WHERE id='" + id + "'";
cmd.ExecuteNonQuery();
  con.Close();            
}