How to convert date format(dd/mm/yyyy) having values with AM and PM into format (yyyy-mm-dd).
Source:
-----
Date_Column (datatype)
----------------------------
3/5/2019 12:24:36 AM Varchar2(24)
12/6/2019 09:34:56 PM Varchar2(24)
9/12/2019 04:12:35 AM Varchar2(24)
1/10/2019 02:37:28 PM Varchar2(24)
I want to convert date values like below output
Date_column(datatype)
-------------------------
2019-05-03 Date
2019-06-12 Date
2019-12-09 Date
2019-10-01 Date
Please help me how to convert as my desired output.
Thanks,
Vasu