how to convert ‘202109’ to 2021-09 in mysql

how to convert ‘202109’ to 2021-09 in MySQL,

I tied

select STR_TO_DATE('202109', '%Y-%m')
and
select DATE('202109', '%Y-%m')

all failed,

Answers:

Thank you for visiting the Q&A section on Magenaut. Please note that all the answers may not help you solve the issue immediately. So please treat them as advisements. If you found the post helpful (or not), leave a comment & I’ll get back to you as soon as possible.

Method 1

I hope you have string. So I think no need to deal with date.

SELECT INSERT('202109', 5, 0, '-');

Method 2

Change %Y-%m to %Y%m them just use DATE_FORMAT to get formart what you want

select DATE_FORMAT( STR_TO_DATE('202109', '%Y%m'), '%Y-%m') as ym_formart

All methods was sourced from stackoverflow.com or stackexchange.com, is licensed under cc by-sa 2.5, cc by-sa 3.0 and cc by-sa 4.0