title: Hardcode a specific day in data time while pulling the data - SQL
body: <p>Actually I have different date in SQL table when I pull those via SQL query, day of datetime field should have fixed day.</p>
  
  <p><strong>Example:</strong> (DD-MM-YYYY) day should be "7" > (7-MM-YYYY)</p>
  
  <ul>
  <li><strong>10</strong>-08-2007 > <strong>07</strong>-08-2007</li>
  <li><strong>27</strong>-12-2013 > <strong>07</strong>-12-2013</li>
  <li><strong>01</strong>-03-2017 > <strong>07</strong>-03-2017</li>
  </ul>
  
  <p>Can someone help me on this. Thanks in Advance.</p>