title: How to get just the date part of getdate()?
body: <p>I have a SQL table that has a CreationDate field.</p>
  
  <p>I have <code>getdate()</code> in the computed column specification formula.</p>
  
  <p>I would like to know how to get just the date portion, that is, '2012-08-24' instead of '2012-08-24 10:45:17.740'.</p>