Unanswered: Problem with datetime
I have these codes
but I don't know why the datetime column is stored as
string str2 = DateTime.Parse(str.Substring(0, pos1) + " 9:30:00").AddHours(6).ToString("yyyy'/'MM'/'dd HH':'mm':'ss");
sql = "update package set sms_time = STR_TO_DATE('" + str2 + "','%Y/%c/%e %H:%i:%s') "
+ "where id = " + id.Text + " ";
that is an AM time, while as expected, it should be PM instead.
Many Thanks & Best Regards,