我们在进行数据模拟或者系统测试时需要随机产生一组时间日期数据,那么你知道如何产生这样的数据吗?
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/0e2442a7d933c8951b49b983dd1373f082020016?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
首先我们制造一个基准时间,这里用=now来获取当前的系统时间。当然你可以用其它方法构造,也可以自己输入。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/c9fcc3cec3fdfc033e4fc240d83f8794a4c22616?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
因为日期和时间的本质都是数据,所以我们用基准日期-一个随机小数,得到的就是最近24小时内的一个随机日期时间了。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/dc54564e9258d10935018f4add58ccbf6d814d63?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
=rand()函数产生的就是一个随机小数,这是函数参数说明。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/43a7d933c895d1436641c5db7ff082025aaf0716?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
我们用基准时间减去一个范围内的整数,就可以将基准日期向前推进n天啦。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/30adcbef76094b36fa5a3d15afcc7cd98c109d79?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
6
=randbetween(最小值,最大值)函数就是产生一个范围内的随机整数,这是函数参数说明。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/32fa828ba61ea8d36ec052fc9b0a304e241f5863?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)