mysql 取随机日期
 

SELECT FLOOR(7 + (RAND() * 6)); 取7到12的随机整数，包括7到12
select floor(12+(rand()*13)); 取12到24的随机整数，包括12到24

concat(createtime,' ',floor(12+(rand()*13)),':',floor(10+(rand()*49)),':',floor(10+(rand()*49)))
格式 ： 2008-12-11 17:43:11

insert into mobilephoto(imageurl,createtime,type,updatedatetime) values('200811166.jpg','2008-11-16',1,concat(createtime,' ',floor(12+(rand()*13)),':',floor(10+(rand()*49)),':',floor(10+(rand()*49))));