<div>
SQL expert PortletPaul wrote an excellent article on <a href="https://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/A_12315-SQL-Server-Date-Styles-formats-using-CONVERT.html" rel="ugc">SQL Server Date Styles (formats) using CONVERT() </a> that shows this and a ton of other date formats ...
<pre><code id="code-20-39636020-1">Declare @dt date = '1951-07-15'
SELECT convert(varchar, @dt ,110)</code></pre>
</div>


SQL expert PortletPaul wrote an excellent article on SQL Server Date Styles (formats) using CONVERT() [https://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/A_12315-SQL-Server-Date-Styles-formats-using-CONVERT.html] that shows this and a ton of other date formats ...

Declare @dt date = '1951-07-15'
SELECT convert(varchar, @dt ,110)

<div>
the statement above is for 1 date. &nbsp;I have 1300 dates to convert. &nbsp;How would I update this SQL statement to the desired date format? &nbsp;<br />
<br />
select LASTNAME, FRSTNAME, BRTHDATE, DIVISIONCODE_I, DEPRTMNT<br />
from UPR00100<br />
where EMPLCLAS &lt;&gt;&nbsp;'terminated' <br />
order by EMPLCLAS
</div>


the statement above is for 1 date.  I have 1300 dates to convert.  How would I update this SQL statement to the desired date format?  

select LASTNAME, FRSTNAME, BRTHDATE, DIVISIONCODE_I, DEPRTMNT
from UPR00100
where EMPLCLAS <> 'terminated'
order by EMPLCLAS

<div>
<div class="content wysiwyg-content">
How do I change a date format of 1951-07-15 to 07-15-1951?<br />
<br />
thanks!
</div>
</div>


How do I change a date format of 1951-07-15 to 07-15-1951?

thanks!

SQL statement (date format)

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Most development for the Microsoft platform is done utilizing the technologies supported by the.NET framework. Other development is done using Visual Basic for Applications (VBA) for programs like Access, Excel, Word and Outlook, with PowerShell for scripting, or with SQL for large databases.