title: Query where date = '2016/01/02' not working?
body: <p><a href="http://sqlfiddle.com/#!6/b18868/1" rel="nofollow">SQL FIDDLE DEMO HERE</a></p>
  
  <p>I have this structure of table:</p>
  
  <pre><code>CREATE TABLE Department
  (
       [IdDepartment] int, 
       [Name] varchar(23), 
       [IdUser] int, 
       [CreateDate] datetime
  );
  
  INSERT INTO Department ([IdDepartment], [Name], [IdUser], [CreateDate])
  VALUES
      (1, 'Sales', 3, '2016-01-15 17:00:00.000'),
      (2, 'Finance', null, '2016-01-13 18:00:00.000' ),
      (3, 'Accounting' , 5, '2016-03-21 22:00:00.000'),
      (4, 'IT' ,3, '2016-03-21 17:00:00.000'),
      (5, 'Secretary',null, '2016-03-21 17:00:00.000'),
      (6, 'Sport',3, '2016-02-20 16:00:00.000');
  </code></pre>
  
  <p>I want to run this query:</p>
  
  <pre><code>select Name 
  from Department 
  where CreateDate = '2016-03-21'
  </code></pre>
  
  <p>This returns 0 rows as a result.</p>
  
  <p>I think it is because the date in the table structure is a datetime but I try to do this and neither works for me:</p>
  
  <pre><code>select Name 
  from Department 
  where CreateDate like '%2016-03-21%'
  </code></pre>
  
  <p>The result should be this:</p>
  
  <pre><code>Name
  -----
  Accounting
  IT
  Secretary
  </code></pre>
  
  <p>How can I get this result?</p>
  
  <p>I hope I explained clearly, thanks</p>