Insert/ Update random date in MySQL by @thinkcyber — August 7, 2014 in MySQL / Programming / Thinkcyber UPDATE mytable SET col = CURRENT_TIMESTAMP - INTERVAL FLOOR(RAND() * 14) DAY