Created
March 27, 2023 14:05
-
-
Save pravodev/79383ee7091a23a33e9102b8e05ce8f3 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
BEGIN | |
DECLARE umur INT; | |
DECLARE result VARCHAR(5); | |
SET umur = TIMESTAMPDIFF(YEAR, tanggal_lahir, CURDATE()); | |
IF(umur >= 0 AND umur <= 4) THEN | |
SET result = '0-4'; | |
ELSEIF(umur >= 5 AND umur <= 9) THEN | |
SET result = '5-9'; | |
ELSEIF(umur >= 10 AND umur <= 14) THEN | |
SET result = '10-14'; | |
ELSEIF(umur >= 15 AND umur <= 19) THEN | |
SET result = '15-19'; | |
ELSEIF(umur >= 20 AND umur <= 24) THEN | |
SET result = '20-24'; | |
ELSEIF(umur >= 25 AND umur <= 29) THEN | |
SET result = '25-29'; | |
ELSEIF(umur >= 30 AND umur <= 34) THEN | |
SET result = '30-34'; | |
ELSEIF(umur >= 35 AND umur <= 39) THEN | |
SET result = '35-39'; | |
ELSEIF(umur >= 40 AND umur <= 44) THEN | |
SET result = '40-44'; | |
ELSEIF(umur >= 45 AND umur <= 49) THEN | |
SET result = '45-49'; | |
ELSEIF(umur >= 50 AND umur <= 54) THEN | |
SET result = '50-54'; | |
ELSEIF(umur >= 55 AND umur <= 59) THEN | |
SET result = '55-59'; | |
ELSEIF(umur >= 60 AND umur <= 64) THEN | |
SET result = '60-64'; | |
ELSEIF(umur >= 65 AND umur <= 69) THEN | |
SET result = '65-69'; | |
ELSEIF(umur >= 70 AND umur <= 74) THEN | |
SET result = '70-74'; | |
ELSEIF(umur >= 75) THEN | |
SET result = '75+'; | |
END IF; | |
RETURN result; | |
END |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment