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