By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
SET @date := "1Q1993"
SELECT CONCAT(SUBSTRING_INDEX(@date,'Q',-1),
CASE SUBSTRING_INDEX(@date,'Q',1)
WHEN 1 THEN '-03-31'
WHEN 2 THEN '-06-30'
WHEN 3 THEN '-09-30'
ELSE '-12-31' END)
| CONCAT(SUBSTRING_INDEX(@date,'Q',-1), CASE SUBSTRING_INDEX(@date,'Q',1) WHEN 1 THEN '-03-31' WHEN 2 THEN '-06-30' WHEN 3 THEN '-09-30' ELSE '-12-31' END) |
|---|
| 1993-03-31 |