I have someone who built a database and put in many tables dates but they used char and the dates are in there like:
If I just do a copy paste of a few into Excel and then go from that to Date I get the date like it should be. The above would look like this if I click in Excel Date:
If I can figure out how to view them in a select like a date should look then I can fix the tables that look like this with an update query. Any advice besides going back to the person and having them import everything again? It took them several weeks to build this and I want to go back and say run this. I know update queries to fix stuff like this are much faster. I have run into date issues but mine have always been the format you see 11/25/2014 and I need to change it to 2014-11-25.
Solved! Go to Solution.
I think the following will fix this for you.
SELECT DATE '1899-12-30' + 41968;
This gives your result from below:
Your other examples come out correctly as well.