title: SQL How to set Constraint date default format MM-DD-YYYY
body: <p>I have a field date name modified.</p>
  
  <p>My goal to get date update with format <code>MM-DD-YYYY</code> when insert or update records.</p>
  
  <p>In the property, I set datatype = date and on the date value and binding option of this field, how to I set to get the date format <code>MMDDYYYY</code></p>
  
  <p>If I use (<code>getdate</code>) then I got format <code>YYYYDDMM</code></p>
  
  <p>The reason I asked because I have the query that I want to select the current month</p>
  
  <pre><code>SELECT  modified
     from  Contact
     where modified &gt;= Dateadd(Month, Datediff(Month, 0, DATEADD(m, -1, current_timestamp)), 0)
  </code></pre>
  
  <p>Can you correct this query if the date format YYYYDDMM <br>
  Thank you.</p>