title: DateTime with format 'yyyy-MM-dd' not working in SQL Query?
body: <p>i am facing a problem in the sql date conversion query</p>
  
  <pre><code>Declare @time datetime
  set @time = '2014-08-02'
  SELECT CONVERT(VARCHAR(10), @time, 111) 'Date Part Only'
  </code></pre>
  
  <p>The Above Query give me output as '2014/08/02'</p>
  
  <pre><code>SELECT CONVERT(VARCHAR(10), '2014-08-02', 111) 'Date Part Only'
  </code></pre>
  
  <p>But if i give directly above query does not give me '2014/08/02' but instead it gives me '2014-08-02'</p>
  
  <p>Why cant i give the date direcly? </p>