Cast some literals in one row: '42'::int + 8 as num, round(3.7) cast to int as rounded, 'yes' cast to boolean as flag, and DATE '2023-06-01' as d.
Cast some literals in one row: '42'::int + 8 as num, round(3.7) cast to int as rounded, 'yes' cast to boolean as flag, and DATE '2023-06-01' as d.
Answer
SELECT '42'::int + 8 AS num, round(3.7)::int AS rounded, 'yes'::boolean AS flag, DATE '2023-06-01' AS d;