Is is possible to convert a string/text type into a date (where it is YY-MMM-DD)

Can someone show me?

Thanks in advance.