title: Time and datetime format with Informix and .NET
body: <p>I have a table which has <code>starttime</code> field.this field of type <code>DateTime</code> and I configure it to <code>(Hour to Minute) in Specials</code>, because I wanna to store only time in this format.</p>
  
  <p>ex:<code>10:45</code></p>
  
  <p>Now in my code :
  I have the following problem:</p>
  
  <pre><code> prd.StartTime = DateTime.Parse(record[1]);//.ToString("H:m"));
  
  
  After Tracing: `StartTime = 6/22/2011 10:45:00 AM`
  </code></pre>
  
  <p>When I insert a record in this table, I get the following exception:</p>
  
  <pre><code>IBM.Data.Informix.IfxException: ERROR [22008] [Informix .NET provider][Informix]
  Non-numeric character in datetime or interval.
  </code></pre>
  
  <p><strong>EDIT:</strong>
  When I make <code>default value</code> enabled to this field and try to insert without <code>starttime</code>, and select the value I found it was <code>17:48</code>, and when I change the Special to <code>Year</code> again the default value is <code>2011-06-22 17:48:00</code>.</p>
  
  <hr>
  
  <p><strong>EDIT2:</strong></p>
  
  <p>I make <code>StartTime</code> property as <code>string</code> rather than <code>DateTime</code>, and succeed to insert. Does this affect the validity of this field later.</p>