MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE FUNCTION concatenate(name CHAR(24), birthday DATE)
RETURNS CHAR(50)
BEGIN
  RETURN CONCAT_WS(' ', name, 'Birthday is', DATE_FORMAT(Y, '%b %d, %Y'));
END
select concatenate('Tim', now())
CREATE TABLE persons (
  name VARCHAR(100),
  birthday DATE
);

INSERT INTO persons VALUES
  ('Tim', '1990-01-01'),
  ('John', '1980-01-01');
SELECT CONCAT_WS(' ', name, 'Birthday is', DATE_FORMAT(birthday, '%b %d, %Y'))
FROM persons


CONCAT_WS(' ', name, 'Birthday is', DATE_FORMAT(birthday, '%b %d, %Y'))


Tim Birthday is Jan 01, 1990

John Birthday is Jan 01, 1980