<div>
I just want to check that when I use Convert it does not update the actual table?
</div>


I just want to check that when I use Convert it does not update the actual table?

<div>
No. &nbsp;That just selects the data for display/return purposes. &nbsp;The IDEAL way to handle this is to have your application format the date how you desire and allow SQL Server to return dates and not strings.
</div>


No.  That just selects the data for display/return purposes.  The IDEAL way to handle this is to have your application format the date how you desire and allow SQL Server to return dates and not strings.

<div>
<div class="content wysiwyg-content">
I am trying to convert 16/08/1960 00:00:00 into 16/08/1960<br />
<br />
i have used <br />
<br />
CONVERT(DateTime, Referral_date, 103) <br />
<br />
but it does not work<br />

</div>
</div>


I am trying to convert 16/08/1960 00:00:00 into 16/08/1960

i have used 

CONVERT(DateTime, Referral_date, 103) 

but it does not work


Convert datetime to date

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.