title: Like operator in Datetime column
body: <p>I want to use Like operator in a column of datetime. The values of the column is as follows:<br>
  2013-08-31 17:54:52.000<br>
  2013-08-31 17:54:52.000</p>
  
  <p>My query is as below:  </p>
  
  <pre><code>SELECT * FROM table where created_date Like '%54%'  
  </code></pre>
  
  <p>It works fine. but when I search for '%52%' instead of '%54%', it gives me nothing. (It is working when I search till the minutes, but when I search for seconds or milli seconds it does not work.)</p>
  
  <p>I have looked at the following url and it is working<br>
  <a href="https://stackoverflow.com/questions/11985536/sql-like-statement-on-a-datetime-type">SQL LIKE Statement on a DateTime Type</a></p>
  
  <p>I want to know the reason, why this is happening and how like operator works with datetime type column. </p>