ALTER TABLE plannedconsignments_tpdetails
ALTER COLUMN exit_date TYPE DATE USING exit_date::date;