如何随机的生成某个日期段的日期

[themass]

如何随机的生成某个日期段的日期
比如我想生成2006-01-11 到2006-06-19 日期,请问怎么处理呀,需要避免生成周6,日的日期不生成

[wj021chen]

mark..

[shweze]

我写了个.net的程序，你看一下：

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
Random r = new Random();
DateTime dt = new DateTime();
int month = r.Next(1, 6);
int day;
do
{
if ((month == 1) || (month == 3) || (month == 5))
day = r.Next(1, 31);
else if (month != 2)
day = r.Next(1, 30);
else
day = r.Next(1, 28);

string day1, time;
if (day < 10)
day1 = "0" + day;
else
day1 = day.ToString();
time = "2006-0" + month + "-" + day1;
dt = Convert.ToDateTime(time);
Response.Write(dt);

Response.Write(dt.DayOfWeek);
}
while ((Convert.ToString(dt.DayOfWeek) == "Saterday") || (Convert.ToString(dt.DayOfWeek) == "Sunday"));
}
}

[任亚军]

先把这些日期存到数组里
然后用星期检查函数去掉某些日期
然后再重新排序
再打乱顺序(这步暂不会)
完了

[超级大笨狼]

<SCRIPT LANGUAGE=vbscript >
'洗牌
Dim N,S,D,P
P=54'牌的数量
Set D = CreateObject("Scripting.Dictionary")
do while D.Count<P
Randomize
N=Int(P * Rnd + 1)
if not D.Exists(cstr(N)) then
D.Add cstr(N),cstr(N)
end if
loop
for each K in D.Keys
S=S & K & " "
next
msgbox replace(trim(S)," ",",")
</SCRIPT>

access
select top 5 * from [table] order by rnd(id)

sql server
select top 5 * from [table] order by newid()