I’m trying to convert my string field to date field in my Databricks 10.4 LTS. So I wrote following query

select to_timestamp(joiningDate,'Mon DD YYYY hh:MI a') from employee

My sample JoiningData contains data in below format

|joiningDate           |
|                      |
________________________
| Mar 15 1978 2:15 PM  |
| Apr 12 1983 11:11 AM |  

But I’m getting error message saying that
IllegalArgumentException:Illegal pattern character ‘o’
Can you please guide me to resolve the issue?