title: SQL: How to compare datetime with whitespace
body: <p>I have a column<code>date</code> and it is type of <code>datetime</code> with format <code>YYYY-MM-DD HH:MM:SS.000</code></p>
  
  <p>my problem is for some dates there is a single space and others there are two spaces between the date and the time </p>
  
  <p>eg.</p>
  
  <pre><code>2009-08-20 13:44:12.753
  2009-08-20  13:44:12.753
  </code></pre>
  
  <p>even though the times are the same when i try compare them they do not match due to the whitespace. i have tried using the <code>replace(date, ' ', '')</code> function but this does not keep the datetime format correctly <code>Aug2020091:44PM</code></p>
  
  <p>how would i compare these dates to ignore the whitespace but not affect the datetime itself?</p>