Home » Development » Transform malformed MySQL dates … String to Date
I am currently working on a client project with a custom solution from someone else, that has messy date strings all over … oh what fun :)
STR_TO_DATE to the rescue! [MySQL Date functions]
’21-02-2016′, ‘%d-%m-%Y’ does the magic and tells STR_TO_DATE how to treat the string.
Get in touch
I am a full-stack developer. My expertise include:
I love programming, design and know my way around server architecture as well. I would never feel complete, with one of these missing.
I have a broad range of interests, that’s why I constantly dive into new technologies and expand my knowledge where ever required. Technologies are evolving fast and I enjoy using the latest.
Apart from that, I am a peace loving guy who tries to have people around him that think the same. I truly believe in the principle: “If you help someone, someone will help you, when you need it."