Trigger before insert

Hi there, Tried to use date_format(sysdate(), '%y-%m-%d') but it got me an error message. When I used sysdate() then it's fine in the trigger exercise. Why is this? Anything wrong or I need to change setting for my Workbench? DELIMITER $$ CREATE TRIGGER check_hire_date
BEFORE INSERT ON employees
FOR EACH ROW
BEGIN

IF NEW.hire_date > SYSDATE() THEN
SET NEW.hire_date = sysdate();
END IF;
END$$ DELIMITER ; ##### official solution is as follows: CREATE TRIGGER trig_hire_date
BEFORE INSERT ON employees
FOR EACH ROW
BEGIN
IF NEW.from_date > date_format(sysdate(), '%Y-%m-%d') THEN
SET NEW.from_date = date_format(sysdate(), '%Y-%m-%d');
END IF;
END $$ DELIMITER ;