我现在要读取数据库中的两个日期,求其差,但要去除星期天和星期六,改怎么办,有没有什么函数?感谢各位!
解决方案 »
- C#将\uxxxx转换成中文
- 启动调试错误:不安全代码只会在使用 /unsafe 编译的情况下出现
- iis中asp.net版本: 下拉框无法选择
- C#编译以后程序体积很小,但是为什么会是这样呢?
- gridview里checkbox控件的单击事件中怎么取该行的值
- ListView閃爍太厲害,如何為它開啟DoubleBuffered
- 程序已经弄好了,但是有个地方不是很动原理,请讲解一下
- 问问各位,获取摄像头的程序和获取视频采集卡的程序是不是一样的?
- 关于.net Gridview 中动态提取字段值 的问题
- 触发事件的问题
- 关于webBrowser使用Socks5代理的问题
- C# List集合排序问题
-- 代码已经测试过
create table SatSun2([id] int identity(1,1),[date] datetime,[weekday] char(6))
godeclare @datetime datetime,@weekday char(6)
set @datetime='2010-1-1'
while @datetime<='2010-12-31'
begin
select @weekday=datename(weekday,@datetime)
if @weekday NOT IN ( 'Saturd' ,'Sunday') insert SatSun2([date],[weekday]) values(@datetime,@weekday)select @datetime=dateadd(day,1,@datetime)
end
goselect * from satsun2drop table satsun1
id date weekday
----------- ----------------------- -------
1 2010-01-01 00:00:00.000 Friday
2 2010-01-04 00:00:00.000 Monday
3 2010-01-05 00:00:00.000 Tuesda
4 2010-01-06 00:00:00.000 Wednes
5 2010-01-07 00:00:00.000 Thursd
6 2010-01-08 00:00:00.000 Friday
7 2010-01-11 00:00:00.000 Monday
8 2010-01-12 00:00:00.000 Tuesda
9 2010-01-13 00:00:00.000 Wednes
10 2010-01-14 00:00:00.000 Thursd
11 2010-01-15 00:00:00.000 Friday
12 2010-01-18 00:00:00.000 Monday
13 2010-01-19 00:00:00.000 Tuesda
14 2010-01-20 00:00:00.000 Wednes
15 2010-01-21 00:00:00.000 Thursd
16 2010-01-22 00:00:00.000 Friday
17 2010-01-25 00:00:00.000 Monday
18 2010-01-26 00:00:00.000 Tuesda
19 2010-01-27 00:00:00.000 Wednes
20 2010-01-28 00:00:00.000 Thursd
21 2010-01-29 00:00:00.000 Friday
22 2010-02-01 00:00:00.000 Monday
23 2010-02-02 00:00:00.000 Tuesda
24 2010-02-03 00:00:00.000 Wednes
25 2010-02-04 00:00:00.000 Thursd
26 2010-02-05 00:00:00.000 Friday
27 2010-02-08 00:00:00.000 Monday
28 2010-02-09 00:00:00.000 Tuesda
29 2010-02-10 00:00:00.000 Wednes
30 2010-02-11 00:00:00.000 Thursd
31 2010-02-12 00:00:00.000 Friday
32 2010-02-15 00:00:00.000 Monday
33 2010-02-16 00:00:00.000 Tuesda
34 2010-02-17 00:00:00.000 Wednes
35 2010-02-18 00:00:00.000 Thursd
36 2010-02-19 00:00:00.000 Friday
37 2010-02-22 00:00:00.000 Monday
38 2010-02-23 00:00:00.000 Tuesda
39 2010-02-24 00:00:00.000 Wednes
40 2010-02-25 00:00:00.000 Thursd
41 2010-02-26 00:00:00.000 Friday
42 2010-03-01 00:00:00.000 Monday
43 2010-03-02 00:00:00.000 Tuesda
44 2010-03-03 00:00:00.000 Wednes
45 2010-03-04 00:00:00.000 Thursd
46 2010-03-05 00:00:00.000 Friday
47 2010-03-08 00:00:00.000 Monday
48 2010-03-09 00:00:00.000 Tuesda
49 2010-03-10 00:00:00.000 Wednes
50 2010-03-11 00:00:00.000 Thursd
51 2010-03-12 00:00:00.000 Friday
52 2010-03-15 00:00:00.000 Monday
53 2010-03-16 00:00:00.000 Tuesda
54 2010-03-17 00:00:00.000 Wednes
55 2010-03-18 00:00:00.000 Thursd
56 2010-03-19 00:00:00.000 Friday
57 2010-03-22 00:00:00.000 Monday
58 2010-03-23 00:00:00.000 Tuesda
59 2010-03-24 00:00:00.000 Wednes
60 2010-03-25 00:00:00.000 Thursd
61 2010-03-26 00:00:00.000 Friday
62 2010-03-29 00:00:00.000 Monday
63 2010-03-30 00:00:00.000 Tuesda
64 2010-03-31 00:00:00.000 Wednes
65 2010-04-01 00:00:00.000 Thursd
66 2010-04-02 00:00:00.000 Friday
67 2010-04-05 00:00:00.000 Monday
68 2010-04-06 00:00:00.000 Tuesda
69 2010-04-07 00:00:00.000 Wednes
70 2010-04-08 00:00:00.000 Thursd
71 2010-04-09 00:00:00.000 Friday
72 2010-04-12 00:00:00.000 Monday
73 2010-04-13 00:00:00.000 Tuesda
74 2010-04-14 00:00:00.000 Wednes
75 2010-04-15 00:00:00.000 Thursd
76 2010-04-16 00:00:00.000 Friday
77 2010-04-19 00:00:00.000 Monday
78 2010-04-20 00:00:00.000 Tuesda
79 2010-04-21 00:00:00.000 Wednes
80 2010-04-22 00:00:00.000 Thursd
81 2010-04-23 00:00:00.000 Friday
82 2010-04-26 00:00:00.000 Monday
83 2010-04-27 00:00:00.000 Tuesda
84 2010-04-28 00:00:00.000 Wednes
85 2010-04-29 00:00:00.000 Thursd
86 2010-04-30 00:00:00.000 Friday
87 2010-05-03 00:00:00.000 Monday
88 2010-05-04 00:00:00.000 Tuesda
89 2010-05-05 00:00:00.000 Wednes
90 2010-05-06 00:00:00.000 Thursd
91 2010-05-07 00:00:00.000 Friday
92 2010-05-10 00:00:00.000 Monday
93 2010-05-11 00:00:00.000 Tuesda
94 2010-05-12 00:00:00.000 Wednes
95 2010-05-13 00:00:00.000 Thursd
96 2010-05-14 00:00:00.000 Friday
97 2010-05-17 00:00:00.000 Monday
98 2010-05-18 00:00:00.000 Tuesda
99 2010-05-19 00:00:00.000 Wednes
100 2010-05-20 00:00:00.000 Thursd
101 2010-05-21 00:00:00.000 Friday
102 2010-05-24 00:00:00.000 Monday
103 2010-05-25 00:00:00.000 Tuesda
104 2010-05-26 00:00:00.000 Wednes
105 2010-05-27 00:00:00.000 Thursd
106 2010-05-28 00:00:00.000 Friday
107 2010-05-31 00:00:00.000 Monday
108 2010-06-01 00:00:00.000 Tuesda
109 2010-06-02 00:00:00.000 Wednes
110 2010-06-03 00:00:00.000 Thursd
111 2010-06-04 00:00:00.000 Friday
112 2010-06-07 00:00:00.000 Monday
113 2010-06-08 00:00:00.000 Tuesda
114 2010-06-09 00:00:00.000 Wednes
115 2010-06-10 00:00:00.000 Thursd
116 2010-06-11 00:00:00.000 Friday
117 2010-06-14 00:00:00.000 Monday
118 2010-06-15 00:00:00.000 Tuesda
119 2010-06-16 00:00:00.000 Wednes
120 2010-06-17 00:00:00.000 Thursd
121 2010-06-18 00:00:00.000 Friday
122 2010-06-21 00:00:00.000 Monday
123 2010-06-22 00:00:00.000 Tuesda
124 2010-06-23 00:00:00.000 Wednes
125 2010-06-24 00:00:00.000 Thursd
126 2010-06-25 00:00:00.000 Friday
127 2010-06-28 00:00:00.000 Monday
128 2010-06-29 00:00:00.000 Tuesda
129 2010-06-30 00:00:00.000 Wednes
130 2010-07-01 00:00:00.000 Thursd
131 2010-07-02 00:00:00.000 Friday
132 2010-07-05 00:00:00.000 Monday
133 2010-07-06 00:00:00.000 Tuesda
134 2010-07-07 00:00:00.000 Wednes
135 2010-07-08 00:00:00.000 Thursd
136 2010-07-09 00:00:00.000 Friday
137 2010-07-12 00:00:00.000 Monday
138 2010-07-13 00:00:00.000 Tuesda
139 2010-07-14 00:00:00.000 Wednes
140 2010-07-15 00:00:00.000 Thursd
141 2010-07-16 00:00:00.000 Friday
142 2010-07-19 00:00:00.000 Monday
143 2010-07-20 00:00:00.000 Tuesda
144 2010-07-21 00:00:00.000 Wednes
145 2010-07-22 00:00:00.000 Thursd
146 2010-07-23 00:00:00.000 Friday
147 2010-07-26 00:00:00.000 Monday
148 2010-07-27 00:00:00.000 Tuesda
149 2010-07-28 00:00:00.000 Wednes
150 2010-07-29 00:00:00.000 Thursd
151 2010-07-30 00:00:00.000 Friday
152 2010-08-02 00:00:00.000 Monday
153 2010-08-03 00:00:00.000 Tuesda
154 2010-08-04 00:00:00.000 Wednes
155 2010-08-05 00:00:00.000 Thursd
156 2010-08-06 00:00:00.000 Friday
157 2010-08-09 00:00:00.000 Monday
158 2010-08-10 00:00:00.000 Tuesda
159 2010-08-11 00:00:00.000 Wednes
160 2010-08-12 00:00:00.000 Thursd
161 2010-08-13 00:00:00.000 Friday
162 2010-08-16 00:00:00.000 Monday
163 2010-08-17 00:00:00.000 Tuesda
164 2010-08-18 00:00:00.000 Wednes
165 2010-08-19 00:00:00.000 Thursd
166 2010-08-20 00:00:00.000 Friday
167 2010-08-23 00:00:00.000 Monday
168 2010-08-24 00:00:00.000 Tuesda
169 2010-08-25 00:00:00.000 Wednes
170 2010-08-26 00:00:00.000 Thursd
171 2010-08-27 00:00:00.000 Friday
172 2010-08-30 00:00:00.000 Monday
173 2010-08-31 00:00:00.000 Tuesda
174 2010-09-01 00:00:00.000 Wednes
175 2010-09-02 00:00:00.000 Thursd
176 2010-09-03 00:00:00.000 Friday
177 2010-09-06 00:00:00.000 Monday
178 2010-09-07 00:00:00.000 Tuesda
179 2010-09-08 00:00:00.000 Wednes
180 2010-09-09 00:00:00.000 Thursd
181 2010-09-10 00:00:00.000 Friday
182 2010-09-13 00:00:00.000 Monday
183 2010-09-14 00:00:00.000 Tuesda
184 2010-09-15 00:00:00.000 Wednes
185 2010-09-16 00:00:00.000 Thursd
186 2010-09-17 00:00:00.000 Friday
187 2010-09-20 00:00:00.000 Monday
188 2010-09-21 00:00:00.000 Tuesda
189 2010-09-22 00:00:00.000 Wednes
190 2010-09-23 00:00:00.000 Thursd
191 2010-09-24 00:00:00.000 Friday
192 2010-09-27 00:00:00.000 Monday
193 2010-09-28 00:00:00.000 Tuesda
194 2010-09-29 00:00:00.000 Wednes
195 2010-09-30 00:00:00.000 Thursd
196 2010-10-01 00:00:00.000 Friday
197 2010-10-04 00:00:00.000 Monday
198 2010-10-05 00:00:00.000 Tuesda
199 2010-10-06 00:00:00.000 Wednes
200 2010-10-07 00:00:00.000 Thursd
201 2010-10-08 00:00:00.000 Friday
202 2010-10-11 00:00:00.000 Monday
203 2010-10-12 00:00:00.000 Tuesda
204 2010-10-13 00:00:00.000 Wednes
205 2010-10-14 00:00:00.000 Thursd
206 2010-10-15 00:00:00.000 Friday
207 2010-10-18 00:00:00.000 Monday
208 2010-10-19 00:00:00.000 Tuesda
209 2010-10-20 00:00:00.000 Wednes
210 2010-10-21 00:00:00.000 Thursd
211 2010-10-22 00:00:00.000 Friday
212 2010-10-25 00:00:00.000 Monday
213 2010-10-26 00:00:00.000 Tuesda
214 2010-10-27 00:00:00.000 Wednes
215 2010-10-28 00:00:00.000 Thursd
216 2010-10-29 00:00:00.000 Friday
217 2010-11-01 00:00:00.000 Monday
218 2010-11-02 00:00:00.000 Tuesda
219 2010-11-03 00:00:00.000 Wednes
220 2010-11-04 00:00:00.000 Thursd
221 2010-11-05 00:00:00.000 Friday
222 2010-11-08 00:00:00.000 Monday
223 2010-11-09 00:00:00.000 Tuesda
224 2010-11-10 00:00:00.000 Wednes
225 2010-11-11 00:00:00.000 Thursd
226 2010-11-12 00:00:00.000 Friday
227 2010-11-15 00:00:00.000 Monday
228 2010-11-16 00:00:00.000 Tuesda
229 2010-11-17 00:00:00.000 Wednes
230 2010-11-18 00:00:00.000 Thursd
231 2010-11-19 00:00:00.000 Friday
232 2010-11-22 00:00:00.000 Monday
233 2010-11-23 00:00:00.000 Tuesda
234 2010-11-24 00:00:00.000 Wednes
235 2010-11-25 00:00:00.000 Thursd
236 2010-11-26 00:00:00.000 Friday
237 2010-11-29 00:00:00.000 Monday
238 2010-11-30 00:00:00.000 Tuesda
239 2010-12-01 00:00:00.000 Wednes
240 2010-12-02 00:00:00.000 Thursd
241 2010-12-03 00:00:00.000 Friday
242 2010-12-06 00:00:00.000 Monday
243 2010-12-07 00:00:00.000 Tuesda
244 2010-12-08 00:00:00.000 Wednes
245 2010-12-09 00:00:00.000 Thursd
246 2010-12-10 00:00:00.000 Friday
247 2010-12-13 00:00:00.000 Monday
248 2010-12-14 00:00:00.000 Tuesda
249 2010-12-15 00:00:00.000 Wednes
250 2010-12-16 00:00:00.000 Thursd
251 2010-12-17 00:00:00.000 Friday
252 2010-12-20 00:00:00.000 Monday
253 2010-12-21 00:00:00.000 Tuesda
254 2010-12-22 00:00:00.000 Wednes
255 2010-12-23 00:00:00.000 Thursd
256 2010-12-24 00:00:00.000 Friday
257 2010-12-27 00:00:00.000 Monday
258 2010-12-28 00:00:00.000 Tuesda
259 2010-12-29 00:00:00.000 Wednes
260 2010-12-30 00:00:00.000 Thursd
261 2010-12-31 00:00:00.000 Friday
set @datetime='2009-1-1'
while @datetime <='2009-12-31'
begin
select @weekday=datename(weekday,@datetime)
if @weekday='星期日' insert SatSun([date],[weekday]) values(@datetime,'星期天')
select @datetime=dateadd(day,1,@datetime)
end
go