Hive query: Convert date timestamp to date format

Question

I want to convert a date timestamp column containing something like '4/12/2023 15:37' to a date format, like: 2023-12-04, using a Hive query. Using the to_date format just returns me null values.

Answer 1

SELECT TO_DATE(FROM_UNIXTIME(UNIX_TIMESTAMP('04/12/2023 15:37', 'd/MM/yyyy HH:mm')));