sql随机日期

select cast(cast(getdate() as int)+cast(rand()*100 as int) as datetime)

posted on 2009-02-09 15:30  zhouwillpower  阅读(581)  评论(0编辑  收藏  举报