In one of our DBs we ended up with imported dates from another system and I basically need to format these so they are all the same. The system they came from was changed frequently and we had a lot of trouble because they were sending us strings with dates formatted all over the place.
I now have these 3 distinct formats in a column:
null dd/mm/yyyy mmm dd yyyy 12:00AM
And I want to change the last date/time format one to dd/mm/yyyy, and also is there a way to check these strings for data that would not normally be in a date format such as dd/mm/yyyy*, so I would be able to recognise only the data and clear out any rubbish in the string.
Don't ask why the imported values were not from date fields, I asked the developer and they said it made it easier for them to import them from the sales system!! however a nightmare on our side as we keep running into date formatting problems as we try to fix the strings into a proper date format.