title: Compare Current Date with LIKE in MS SQL Server
body: <p>I have the date field in this format <code>2016-06-09 10:56:29.000</code> in one of the table. I want to <code>select</code> the records based on the current date like <code>2016-06-09</code>. I am trying the below query but not showing any records.</p>
  
  <pre><code>select * from dbo.Accounts where createDate like CAST(GETDATE() as DATE)
  </code></pre>
  
  <p>I know I am doing something wrong here. Any SQL Expert, please help me.</p>