生成随机年份日期

最新推荐文章于 2025-03-11 10:45:06 发布

原创最新推荐文章于 2025-03-11 10:45:06 发布 · 3.9k 阅读

0 ·

本内容遵循CC 4.0 BY-SA版权协议

收录于

SQL2005学习日志

本文介绍了一个使用T-SQL编写的存储过程，用于生成随机日期。该过程考虑了不同月份的天数差异及闰年情况，确保生成的日期合理有效。

create proc Proc_RandDateTime @OutRandDate datetime output as begin declare @RandDate datetime declare @strDate varchar(8) select @strDate = (CHAR((CONVERT(int,RAND()*1000)%10)+48) +CHAR((CONVERT(int,RAND()*1000)%10)+48) +CHAR((CONVERT(int,RAND()*1000)%10)+48) +CHAR((CONVERT(int,RAND()*1000)%10)+48)) declare @year int set @year = convert(int,@strDate) declare @month int set @month = (convert(int,(rand()*1000)) % 12 + 1) declare @day int if @year <= 1900 begin set @year = 1900 set @strDate = convert(char(4),year(1900-01-01)) end if (((@year % 4) = 0 and (@year % 100) != 0 ) or ( (@year % 100) = 0 and (@year % 400) = 0 )) and (@month = 2) begin set @day = convert(int,(rand()*1000))%28 + 1 end else if ((@month = 1) or (@month = 3) or (@month = 5) or (@month = 7) or (@month = 8) or (@month = 10) or (@month = 12)) begin set @day = convert(int,(rand()*1000))%31 + 1 end else begin set @day = convert(int, (rand()*1000))%30 + 1 end set @strDate = (@strDate + char(@month/10 + 48 ) + char(@month%10 + 48 ) + char(@day/10 + 48 ) + char(@day%10 + 48 )) set @RandDate = convert(datetime,@strDate) select @OutRandDate = @RandDate end