Hi,

I have these codes
Code:
                    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 + " ";

                    DBUtil.ExecuteNonQuery(conn, sql);
but I don't know why the datetime column is stored as
2015-04-01 03:30:00

that is an AM time, while as expected, it should be PM instead.