After converting character to Date for "May 1, 2023", it shows incorrect result "2023-01-20"

Suppose you have a character column containing text like “May 1, 2023”
image

And try to convert it to date from the column menu.

This ends up with incorrect results like “2023-01-20”.

If this is the case, then select the locale “English_United States” as follows, and it shows the correct result “2023-05-01”