Skip to content

Instantly share code, notes, and snippets.

@pravodev
Created March 27, 2023 14:05
Show Gist options
  • Save pravodev/79383ee7091a23a33e9102b8e05ce8f3 to your computer and use it in GitHub Desktop.
Save pravodev/79383ee7091a23a33e9102b8e05ce8f3 to your computer and use it in GitHub Desktop.
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