<div>
select convert(varchar(20),getdat<wbr />e(),103)<br />
<br />
this will give you the date in dd/mm/yyyy format.
</div>


select convert(varchar(20),getdate(),103)

this will give you the date in dd/mm/yyyy format.

<div>
SELECT CAST((substring(@cDate,7,2<wbr />)+'/'+subs<wbr />tring(@cDa<wbr />te,5,2)+'/<wbr />'+ substring(@cDate,1,4)) as nvarchar(10))
</div>


SELECT CAST((substring(@cDate,7,2)+'/'+substring(@cDate,5,2)+'/'+ substring(@cDate,1,4)) as nvarchar(10))

<div>
Replace getdate() below..to the date in your table...<br />
<br />
select convert(varchar(10),yourda<wbr />tefield,10<wbr />3)
</div>


Replace getdate() below..to the date in your table...

select convert(varchar(10),yourdatefield,103)

<div>
oops, where @cDate is your column name:) 
</div>


<div>
<div class="content wysiwyg-content">
I imported a table in which the date format is YYYYMMDD Char(8) and I need to convert the<br />
date to the DD/MM/YYYY varchar(10) format. &nbsp;Is there an update statement or something<br />
equivalent to make this conversion painless? &nbsp;Thanks for your help.
</div>
</div>


I imported a table in which the date format is YYYYMMDD Char(8) and I need to convert the
date to the DD/MM/YYYY varchar(10) format.  Is there an update statement or something
equivalent to make this conversion painless?  Thanks for your help.

Convert YYYYMMDD as a Char(8)  to DD/MM/YYYY varchar(10) in SQL 2k

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.