MySQL function for get random datetime in between 2 given datetime. Copy from : https://stackoverflow.com/a/49727273

random_datetime_between.sql

DELIMITER $$

DROP FUNCTION IF EXISTS `random_datetime_between`$$

CREATE FUNCTION `random_datetime_between`(date_from DATETIME, date_to DATETIME) RETURNS DATETIME
BEGIN 
  /**
   * reference: https://stackoverflow.com/a/49727273
   */
  DECLARE result DATETIME;
  SET result = (SELECT FROM_UNIXTIME(
                      UNIX_TIMESTAMP(date_from) + FLOOR(
                          RAND() * (
                              UNIX_TIMESTAMP(date_to) - UNIX_TIMESTAMP(date_from) + 1
                          )
                      )
               ));
  RETURN TIMESTAMP(result);
END$$

DELIMITER ;