Question

select planday,finishday from productinfo where productname='”&textbox1.text&"'

怎么去用datediff 计算这两个值
我自己倒腾出来了-. -
d.commandtext=select datediff(day,planday,planfinishday)a,datediff(day,startday,finishday)b from productinfo where productname='”&textbox1.text&"'
........
dim b as sqlcl...sqlreader=a.executereader
if b.hasrows then
while b,read then
textbox2.text="计划需要"&b("a")&"天"&"实际用了"&"b("b")天"
end while

Answer 1

datediff 返回日期
SELECT DATEDIFF(day,'2008-12-29','2008-12-30') AS DiffDate 返回2个日期之间的天数