I have a very simple tag in a table, structured as tag-DDMMYY. I want to convert that into a date, MM-DD-20YY. Is there an easy way to do this in SQL?
I’m not an expert developer and I feel like this should be quite easy using PatIndex (there’s always only one dash), but I’ve got nowhere so far and I’m hoping someone expert could help.
Link: How to extract a date from a string in SQL?
Source: Stack Sql