Turns out I needed to dive more into Hive functions.

Here's the solution to my problem, using this SQL code I'm able to do the conversion while extracting the column:

SELECT from_unixtime(unix_timestamp('Jan 18 2019 1:54PM', 'MMM dd yyyy h:mma'), 'yyyy-MM-dd HH:mm:00') AS formatted_date;

Result: