framework/resources/Functional/union/VarcharSubstringAndDate.sql

SELECT SUBSTRING('ABC some text', 1, 3) AS ExtractString
UNION
SELECT date '2017-04-06';