asked on
SQL date conversion of 5-digit date
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!
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!
MySQL ServerSQL
Last Comment
Jim Horn
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
<wild guess>
Are you working with an Excel spreadsheet, where dates were imported into it but Excel displays it as a number?
Are you working with an Excel spreadsheet, where dates were imported into it but Excel displays it as a number?
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?