declare @endtime datetime declare @starttime datetime set @starttime=‘2017-09-01‘ set @endtime = ‘2017-11-24‘ declare @ctime datetime select @ctime= dateadd(SECOND,convert(int,(rand()*datediff(SECOND,@starttime,@endtime))),@starttime) Select CONVERT(varchar(100),@ctime, 25) print @ctime
原文：http://www.cnblogs.com/25miao/p/7891795.html