random date generator

Generates a random date string that is used to insert the database.A time period is set by a time tuple, and the start and end times are converted to timestamps.Randomly take one of the timestamps, then generate a time tuple, and then format the time tuple as a stringThe Python2 code is as followsImport timeImport Randoma1= (1976,1,1,0,0,0,0,0,0) #设置开始日期时间元组 (1976-01-01 00:00:00)A2= (1990,12,31,23,59,59,0,0

Label:20150510 Insert a random date add_time (int) in the table, 2014 random dates, preferably every monthDue to the time stamp format stored, one months difference 2678400, a day difference of 86400The function to useSELECT unix_timestamp (' 20141231 ') #1419955200SELECT from_unixtime (1391675501, '%y%m%d%h:%i:%s ')SELECT Floor (1 + (RAND () *)) #随机月份SELECT Floo

Label:Select DATEADD (Dd,datediff (DD, ' 2015-02-01 ', ' 2015-10-31 ') *rand (), ' 2015-02-01 ')Since 2015-02-012015-10-31Select SUBSTRING (CONVERT (CHAR), DATEADD (Dd,datediff (DD, ' 2015-02-01 ', ' 2015-10-31 ') *rand (), ' 2015-02-01 '), 21), 0, 12)Take only the date partSelect SUBSTRING (CONVERT (CHAR), DateAdd (Ms,datediff (MS, ' 08:30:00 ', ' 18:00:00 ') *rand (), ' 08:30:00 '), 21), 12, 13)Time and minute milliseconds are randomly in the specif