title: How to get date representing the first day of a month?
body: <p>I need functionality in a script that will enable me to insert dates into a table.</p>
  
  <p>What SQL do I need to insert a date of the format</p>
  
  <pre><code>01/08/2010 00:00:00
  </code></pre>
  
  <p>where the date is the first day of the current month. What do I need to change order that I can specify the month value? Thanks</p>