How to covert a string to date format ddmonyyyy

Question

I have a string containing date in it.

It looks like:

01JAN2020
02FEB2020

I use the following code to parse it to date format but didn't succeed:

a= a.withColumn('dt_one', to_date(unix_timestamp(col('dt_one'), 'dLy').cast("timestamp")))

Do you know the right syntax to do this?

Thanks!

Answer 1

I think this should work:

a= a.withColumn('dt_one', to_date(unix_timestamp(col('dt_one'), 'dMMMy').cast("timestamp")))