O'Reilly logo
  • Wiktor Bojanowski thinks this is interesting:

Expression

EntStageName || ' was signed with our agency
on ' || CAST(DateEntered as CHARACTER(10))

From

Cover of SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL, Fourth edition

Note

MySQL Example:

SELECT CONCAT(TourneyLocation, " Tournament takes place on ", CAST(TourneyDate AS CHARACTER(10))) FROM Tournament s;