Sql获取随机时间
时间:2011-02-15 来源:Grok.Yao
ALTER PROCEDURE [dbo].[GET_RandomTime]
@starttime datetime,
@endtime datetime,
@Time datetime output
as
declare @id nvarchar(50)
declare @ctime datetime
declare @count int
select @ctime= dateadd(SECOND,convert(int,(rand()*datediff(SECOND,@starttime,@endtime))),@starttime)
set @Time= @ctime
相关阅读 更多 +