Hello

i'm converting hana sql code in databricks. we have 4 columns all in string format, start date, start time, end date, endtime..

1) what expression i can use to convert values of startdate & start time from string format to datetimeformat with AM/PM .? so later i can break final value in to two columns.

expected value:

Startdate ,, Starttime

2022-10-09 01-09-11 am

2022-10-09 -08-20-16 am (3rd row).