<div>
What database?<br />
Is it an actual date data type or a string/varchar data type?
</div>


What database?
Is it an actual date data type or a string/varchar data type?

<div>
you can try this.<br />
<br />

<pre><code id="code-20-42785690-1">select convert(varchar(10), convert(datetime, date_column), 103) from your_table</code></pre>
</div>


you can try this.



select convert(varchar(10), convert(datetime, date_column), 103) from your_table

<div>
&gt;&gt;it is a varchar <br />
What database product?
</div>


Database Administrator / Software Engineer

Tomas Helgi Johannsson

Alex Lord

<div>
I agree i am fixing someone mistake lol
</div>


<div>
<div class="content wysiwyg-content">
<a href="https://filedb.experts-exchange.com/incoming/2019/01_w05/1410792/Screen-Shot-2019-01-29-at-16.03.34.png" target="_blank" title="dates (6 KB)"><img alt="dates" class="file-block lazyload" style="max-width: 71px;" data-src="https://filedb.experts-exchange.com/incoming/2019/01_w05/1410792/Screen-Shot-2019-01-29-at-16.03.34.png" /></a><br />
So i have a table with these dates,<br />
<br />
they are in wrong format,<br />
<br />
what sql can i use to reformat these dates to<br />
<br />
day/month/year<br />
<br />
?
</div>
</div>


Screen-Shot-2019-01-29-at-16.03.34.png



So i have a table with these dates,

they are in wrong format,

what sql can i use to reformat these dates to

day/month/year

?

Wrong date format in tables

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.