title: SQL-Date-Question: How to get Yesterdays date in the following formatte
body: <p>Here is What I have So Far</p>
  
  <pre><code>declare @Today smalldatetime
  Set @Today = GETDATE()
  select @Today
  </code></pre>
  
  <p>YIELDS</p>
  
  <pre><code>2011-03-10 13:46:00
  </code></pre>
  
  <p>What I need IS:</p>
  
  <pre><code>2011-03-09
  </code></pre>