change column data type

PHOTO EMBED

Fri Apr 01 2022 08:29:37 GMT+0000 (Coordinated Universal Time)

Saved by @Bambibo9799

ALTER TABLE assets
ALTER COLUMN asset_no TYPE INT 
USING asset_no::integer;

ALTER TABLE assets 
    ALTER COLUMN location TYPE VARCHAR,
    ALTER COLUMN description TYPE VARCHAR;

alter table temp_runner_orders_v2
alter column distancefixed type float
USING distancefixed::double precision;
--
alter table temp_runner_orders_v2
alter column durationfixed  type int
USING durationfixed ::integer ;

--
ALTER TABLE temp_runner_orders_v2  
ALTER COLUMN pickuptimefixed  TYPE DATE USING to_date(pickuptimefixed , 'YYYY-MM-DD');
content_copyCOPY