How to change String version to Date version?

[wendyzjy]

input column Date type is String( if use select to change from string to Date, shows Null)

They format of the Date in the input file is yyyy-mm(eg. 2022-02)

How to change the string format to a date format and sort the 12 months of 6 month earlier than current month?(eg, sort out 2020-07 to 2021-06, suppose the current month is 2022-02) ？

[wendyzjy]

same to you!

[atcodedog05]

_