title: to_date in SQL Server 2005
body: <p>Does any one know how I would have to change the following to work with ms sql?</p>
  
  <pre><code>WHERE registrationDate between to_date ('2003/01/01', 'yyyy/mm/dd')
  AND to_date ('2003/12/31', 'yyyy/mm/dd');
  </code></pre>
  
  <p>What I have read implies I would have to construct it using DATEPART() which could become very long winded. Especially when the goal would be to compare on dates which I receive in the following format "2003-12-30 10:07:42". It would be nice to pass them off to the database as is.</p>
  
  <p>Any pointers appreciated.</p>