title: How to set time to Zeros in DateTime?
body: <p>Lets say I have the following DateTime variable </p>
  
  <pre><code>DateTime CurDate = '26/3/2014 12:00:00 AM';
  </code></pre>
  
  <p>I'm wondering how can I set the <code>CurDate</code> so that the value will become <code>26/3/2014 00:00:00 AM</code></p>
  
  <p>Note that I still want the time, but with all zeros.</p>
  
  <p>**P/S: The reason for having all zeros is because the datetime value stored in SQL Server is <code>26/3/2014 00:00:00.000</code>. I need to cast <code>CurDate</code> to have all zeros in order to match database data</p>