How To Convert Data Format with Chinese words (下午/上午) In T-SQL Script with C# (based on SQL Server with Chinese Version)
<p>I have a problem with <code>SqlCommand</code> in C#, I need to insert <code>DateTime</code> format to SQL Server like as following code</p>

<p><strong>For example</strong></p>

<pre><code>using (SqlConnection conn = new SqlConnection("Data Source=127.0.0.1;Initial Catalog=B2CCompareData;Persist Security Info=True;User ID=sa;Password=1111;MultipleActiveResultSets=True;Connection Timeout=600; Application Name=EntityFramework"))
{
    conn.Open();                    
    SqlCommand cmd = conn.CreateCommand();                   

    try
    {
        cmd.CommandText = "Insert into table1(indexid,createTime) values(1,Convert(datetime, '2016/1/20 下午 04:21:07', 121))";
        cmd.CommandType = CommandType.Text;
        cmd.Connection = conn;                   

        cmd.ExecuteNonQuery();                   
    }
    catch
    {
        throw;
    }
}
</code></pre>

<p><code>2016/1/20 **下午** 04:21:07</code> ==> <strong>The datetime with mixing Chinese words</strong></p>

<p>But unfortunately I get an error message:</p>

<blockquote>
  <p>Conversion failed when converting date and/or time from character
  string.</p>
</blockquote>

<p>So that what can I do to fix this problem?</p>

<p>PS: <code>上午</code> is <code>AM</code> / <code>下午</code> is <code>PM</code> </p>