Conversion error when converting date and / or time from character string
This code worked yesterday, but not now. I haven't changed anything ... Why is this and how can I fix it?
{
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();
}
+3
source to share
2 answers
Ok try this
{
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();
}
+4
source to share