What's the command for SQL to change the date-format : <p>how can I change the Date format form YYYY-MM-DD to DD-MM-YYYY ? I tried this command: </p>

<pre><code>select CONVERT(varchar(10), @date, 101)
</code></pre>

<p>but it did not work. Can anyone help me?</p>

<p>Thanks!</p>
