Datatype mismatch: 7 ERROR: column cannot be cast automatically to type integer code example

Example: Datatype mismatch: 7 ERROR: column cannot be cast automatically to type integer

alter table a.attend alter column terminal TYPE INTEGER  USING (terminal::integer) ;