By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
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 |