ALTER TABLE plannedconsignments_tpdetails
ALTER COLUMN exit_date TYPE TIMESTAMPTZ USING exit_date::timestamptz;