title: Get DateTime with time as 23:59:59
body: <p>I'm trying to do a where statement that specifies a DateTime field is between the start and end of the previous month.</p>
  
  <p>To do this, I need to specify that the first day of the previous month has a time of 00:00:00 and the last day of the previous month has a time of 23:59:59.</p>
  
  <p>This second condition is giving me a headache.. </p>
  
  <p>Can someone help me out?</p>
  
  <p>Cheers</p>
  
  <p>MSSQL 2008</p>