MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

select version();

version()

8.0.20

create table color (c int)
insert into color values (255),(39423),(8421504)
select  hex(( c >> 8 ) | ( (c & 0xffff)  << 16)) from color

hex(( c >> 8 ) | ( (c & 0xffff)  << 16))

FF0000

99FF0099

80808080