ЯсноПонятно24

CREATE FUNCTION convert_seconds_to_days_hours(seconds INT, format VARCHAR(10))
RETURNS VARCHAR(50)
BEGIN
    DECLARE days INT;
    DECLARE hours INT;
    DECLARE result VARCHAR(50);
    
    SET days = seconds DIV 86400;
    SET hours = (seconds % 86400) DIV 3600;
    
    IF format = 'days' THEN
        SET result = CONCAT(days, ' days');
    ELSEIF format = 'hours' THEN
        SET result = CONCAT(hours, ' hours');
    ELSE
        SET result = CONCAT(days, ' days ', hours, ' hours');
    END IF;
    
    RETURN result;
END;

Пример использования:

SELECT convert_seconds_to_days_hours(100000, 'days'); -- Вернет '1 days'
SELECT convert_seconds_to_days_hours(100000, 'hours'); -- Вернет '2 hours'
SELECT convert_seconds_to_days_hours(100000, 'both'); -- Вернет '1 days 3 hours'