title: How to get 00:00:00 in datetime, for First of Month?
body: <p>I wrote a query to obtain First of month, </p>
  
  <pre><code>SELECT DATEADD(DAY, -(DATEPART(DAY,GETDATE())-1), GETDATE()) as First_Of_Month;
  </code></pre>
  
  <p>for which i do get the appropriate output, but my time stamp shows the current time.</p>
  
  <p>Here's what I am doing in the query, hope i make sense.</p>
  
  <p>using <code>datepart</code> i calculated the no. of days (int) between the 1st and today (27-1 =26) 
  Then using <code>dateadd</code> function, i added "-datepart" to get the first of the month.</p>
  
  <p>This is just changing the date, what should i look at or read about in order to change the time. I am assuming that it would have something to do with 19000101</p>