Is there a difference between using curdate() and sysdate()? use employees; DELIMITER $$ CREATE TRIGGER hire_date_check BEFORE INSERT ON employees FOR EACH ROW BEGIN IF NEW.hire_date > curdate() THEN SET NEW.hire_date = curdate(); END IF; END $$ DELIMITER ;

Hi Vladimir and Mohaned! Thanks for reaching out. @: Mohaned Thanks for sharing this piece of information with the Community! @: Vladimir The CURDATE() function returns the time stamp of the client while the SYSDATE() function returns the time stamp of the server. If both server and the client are on the same machine, then, the result of both commands are the same. But in case that your sever is for example in USA and your clients are in China, then, these two functions return completely different results. Hope this helps. Best, Tsvetelin