change column data type
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
Comments