• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 366
  • Last Modified:

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!
0
robthomas09
Asked:
robthomas09
1 Solution
 
arnoldCommented:
There is no way to know exactly what these dates were.  
You have to find the source of the data and get the information.
If you simply enter the number in excel, and then change the cell format to date, you'll get a date in 2045-49 depending on the number.
0
 
PortletPaulfreelancerCommented:
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?
0
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
<wild guess>  
Are you working with an Excel spreadsheet, where dates were imported into it but Excel displays it as a number?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now