Alter column type

ALTER TABLE transactions ALTER COLUMN time TYPE TIMESTAMP USING "time"::timestamp without time zone