How to convert string 'mm-yyyy' column to timestamp in MYSQL?

Question

I want to convert string column of format 'mm-yyyy' to timestamp.

Answer 1

Try this following logic. As you have only Month and Year value in your string, I have added the static date 01 to each date to generate the DATETIME value.

select 
CAST(
    CONCAT(right('06-2019',4) , '-', left('06-2019', 2),'-01') AS DATETIME
);