Collectives™ on Stack Overflow

Find centralized, trusted content and collaborate around the technologies you use most.

Teams

Q&A for work

Connect and share knowledge within a single location that is structured and easy to search.

I have a date column which is in YYYYMMDD or 20120101 format. This is because SAP stores it in this format, so cannot change this.

How can I convert this to a YYYY-MM-DD format in a MySQL query? In DB2, I used a to_date() function.

In MySQL, I'm trying the STR_TO_STRING() function but it returns 'null'.

  SELECT STR_TO_DATE(VBAP.ERDAT,'%Y-%m-%d') FROM VBAP
                Why is your date column in a "format" at all? Why isn't it just a DATE type, which you'd query using parameterized SQL and avoiding conversions to string in the first place?
– Jon Skeet
                Jul 7, 2012 at 11:26
                When you have a constraint like that where a better solution would be obvious if you weren't constrained, it's worth explaining that constraint in the question.
– Jon Skeet
                Jul 8, 2012 at 6:59
                Alright, I thought mentioning that the existing format is in this way was enough. Updated my question.
– kouton
                Jul 8, 2012 at 12:03
        
Thanks for contributing an answer to Stack Overflow!
Please be sure to answer the question. Provide details and share your research!
But avoid …
Asking for help, clarification, or responding to other answers.
Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.