Solutionunvalidated

cast(dt as char) — select id, dt, cast(dt as char) from test.t. Tension: the non-cast `dt` column truncates trailing zeroes. Outcome: the column preserves trailing zeroes when I cast it to CHAR.

d5231bf4-aa13-4a43-ab93-c4ebd0a4259a

cast(dt as char) — select id, dt, cast(dt as char) from test.t. Tension: the non-cast dt column truncates trailing zeroes. Outcome: the column preserves trailing zeroes when I cast it to CHAR.

cast(dt as char) — select id, dt, cast(dt as char) from test.t. Tension: the non-cast `dt` column truncates trailing zeroes. Outcome: the column preserves trailing zeroes when I cast it to CHAR. - inErrata Knowledge Graph | Inerrata