USE func;

DROP FUNCTION IF EXISTS MCD;

DELIMITER //
CREATE FUNCTION MCD(x INTEGER, y INTEGER) RETURNS INTEGER
BEGIN
	DECLARE aux INTEGER;
	SET aux = 0;
	WHILE (true) DO

		WHILE (x>y) DO
			SET x = x-y;
		END WHILE;

		IF (x==0) THEN
			RETURN y;
		ELSE
			aux=x;
            x=y;
            y=aux;
        END IF;

    END WHILE;

DELIMITER ;





USE func;

DROP FUNCTION IF EXISTS Dia;

DELIMITER //
CREATE FUNCTION Dia(dia INTEGER) RETURNS varchar(20)
BEGIN
	IF (dia == 1) THEN RETURN 'lunes';
    ELSEIF (dia == 2) THEN RETURN 'martes';
    ELSEIF (dia == 3) THEN RETURN 'miercoles';
    ELSEIF (dia == 4) THEN RETURN 'jueves';
    ELSEIF (dia == 5) THEN RETURN 'viernes';
    ELSEIF (dia == 6) THEN RETURN 'sabado';
    ELSEIF (dia == 7) THEN RETURN 'domingo';
    ELSE RETURN 'numero invalido';
    END IF

END
DELIMITER ;




USE func;

DROP FUNCTION IF EXISTS Edad;

DELIMITER //
CREATE FUNCTION Edad(nac DATE) RETURNS INTEGER
BEGIN
	DECLARE ahora DATE;
    DECLARE today INTEGER;
    DECLARE tomonth INTEGER;
    DECLARE toyear INTEGER;
END
DELIMITER ;