Thread: Mysql insert random datetime in a given datetime range
View Single Post
  #1   IP: 112.87.30.158
Old 2015-04-19, 06:14 AM
Imperial Imperial is offline
初级会员
  
Join Date: 2011-03-22
Posts: 1
Imperial 现在声名狼藉
Default Mysql insert random datetime in a given datetime range
With SQL , Can I insert random datetime values in a column giving a range? eg. given a range of 2010-04-30 14:53:27 to 2012-04-30 14:53:27

I'm getting confused with the range part. as i will have just done this
Code:
INSERT INTO `sometable` VALUES (RND (DATETIME()))
Reply With Quote