Convert yyyymm String to yyyy-mm-dd hh:mm:ss date time in athena

I am trying to convert a string column "yyyymm" to a "yyyy-mm-dd hh:mm:ss" datetime column in athena.

How can I do this?

https://stackoverflow.com/questions/67206121/convert-yyyymm-string-to-yyyy-mm-dd-hhmmss-date-time-in-athena April 22, 2021 at 10:57AM