title: Get the records of last month in SQL server
body: <p>I want to get the records of last month based on my db table [member] field "date_created".</p>
  
  <p>What's the sql to do this?</p>
  
  <p>For clarification, 
  last month - 1/8/2009 to 31/8/2009</p>
  
  <p>If today is 3/1/2010, I'll need to get the records of 1/12/2009 to 31/12/2009.</p>