Dremio date conversation

Question

How to convert date field "Dec 1 2018 6:38PM" to dd-mm-yyyy (01-12-2018)` in Dremio?

Answer 1

select to_timestamp('Dec 1 2018 6:38PM','mon dd yyyy hh:miAM')

Date/Time formats here: https://docs.dremio.com/sql-reference/sql-functions/datetime-formats.html