title: Convert from MM-DD-YYYY to CCYY-MM-DD in SQL Server 2008
body: <p>I have </p>
  
  <pre><code>,CONVERT (char,Getdate(),110) AS 'date_needed_by'
  </code></pre>
  
  <p>which results in 03-12-2019</p>
  
  <p>However, I need 2019-03-12</p>
  
  <p>I have not spotted this particular format in any of the date guides. </p>