<div>
Please ONLY use tags and topics that relate to your specific question.<br />
<br />
You have listed both MySQL and Microsoft SQL Server, but date processing is very different in those 2 databases.<br />
<br />
Which rdbms and version is actually used here?<br />
<br />
{+edit}<br />
In addition, can you also identify the actual data type of that column? <br />
is it integer?
</div>


Please ONLY use tags and topics that relate to your specific question.

You have listed both MySQL and Microsoft SQL Server, but date processing is very different in those 2 databases.

Which rdbms and version is actually used here?

{+edit}
In addition, can you also identify the actual data type of that column?
is it integer?

<div>
&lt;wild guess&gt; &nbsp;<br />
Are you working with an Excel spreadsheet, where dates were imported into it but Excel displays it as a number?
</div>


<wild guess>  
Are you working with an Excel spreadsheet, where dates were imported into it but Excel displays it as a number?

<div>
<div class="content wysiwyg-content">
Hello experts, <br />
<br />
I am performing a data conversion and came across a date field that lives in a format I havent see. &nbsp;Sample dates are:<br />
<br />
57,277<br />
57,277<br />
55,594<br />
56,179<br />
56,603<br />
57,071<br />
57,534<br />
57,645<br />
56,981<br />
56,792​<br />
<br />
I would love to get this into some type of mm/dd/yyyy format if possible.<br />
<br />
I initially thought it was the excel julian format that could be solved via =TEXT(E7,&quot;mm/dd/yyyy&quot;), but that kicked out crazy future dates, so didnt make any sense.<br />
<br />
Thoughts?<br />
<br />
Thanks!
</div>
</div>


Hello experts, 

I am performing a data conversion and came across a date field that lives in a format I havent see.  Sample dates are:

57,277
57,277
55,594
56,179
56,603
57,071
57,534
57,645
56,981
56,792​

I would love to get this into some type of mm/dd/yyyy format if possible.

I initially thought it was the excel julian format that could be solved via =TEXT(E7,"mm/dd/yyyy"), but that kicked out crazy future dates, so didnt make any sense.

Thoughts?

Thanks!

SQL date conversion of 5-digit date

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.

MySQL Server

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.