Convert to text:
CAST(column as VARCHAR(2048)) AS column
CAST(column as VARCHAR(2048)) AS column
TO_DATE(column, 'YYYYMMDD', 1) AS column
TO_TIME(column, 'HH24MISS', 1) AS column
TO_TIMESTAMP(column, 'YYYYMMDD HH24:MI:SS.FFF', 1) AS column
TO_TIMESTAMP(column, 'YYYY-MM-DD"T"HH24:MI:SS', 1) AS column
CONVERT_TO_FLOAT(column, 1, 1, 0) AS column
CONVERT_FROM(column, 'JSON') AS column
CAST(column as BIGINT) AS column
NULLIF(1,1) as column
LTRIM(CAST(column as VARCHAR(2048)), '0') AS column