Convert date format(dd/mm/yyyy) into format (yyyy-mm-dd)

[system]

How to convert date format(dd/mm/yyyy) into format (yyyy-mm-dd).

I have CSV file with date column having values like below

Date:

3/5/2019 12:24:36 AM
12/6/2019 09:34:56 PM
9/12/2019 04:12:35 AM
1/10/2019 02:37:28 PM

I want to convert date values like below output

2019-05-03
2019-06-12
2019-12-09
2019-10-01

Please help me how to convert as my desired output.

Thanks
Venki

---

ursfriend77 (BOB member since 2011-03-02)

[system]

Try to_date function

---

BOBJFan (BOB member since 2011-09-24)

[system]

print(to_char( to_date( ‘9/12/2019 04:12:35 AM’,‘MM/DD/YYYY HH:MI:SS’),‘YYYY-MM-DD’));

---

jlynn73 (BOB member since 2009-10-27)