title: TSQl: Select Current Date - 6 Days and set time to 12:01 AM
body: <p>I am trying to get current date -  6 days. That is easy.</p>
  
  <p>Now I am trying to get current date -  6 days + 12:01 AM.</p>
  
  <p>So if today is 3-2-2012 11:14 AM. </p>
  
  <p>I want to get 2-25-2012 12:01 AM</p>
  
  <p>These 2 selects will give me current date - 6, but will not reset the time to 12:01 AM</p>
  
  <ul>
  <li>select getdate()-6</li>
  <li>SELECT DATEADD(day, -6, CURRENT_TIMESTAMP);</li>
  </ul>