mysql随机时间

UPDATE enrolment SET create_time = CONCAT('2016-01-', FLOOR(RAND() * 6 + 1), ' ', FLOOR(RAND() * 24), ':', FLOOR(RAND() * 59), ':', FLOOR(RAND() * 59));