我想查小时,下面的语句出错了,请帮忙找找,谢谢 sqlstr:='select sum(cost),sum(datediff(hour,starttime-endtime)) from checkb where (typeno='+''''+typeno+''')and(starttime>'''+datetimetostr(datetimepicker1.datetime)+''')and(endtime<'''+datetimetostr(datetimepicker2.datetime)+''')';
Select datediff(month,'2001-01-01','2002-02-02')两个时间相差多少月
Select datediff(Day,'2001-01-01','2002-02-02')两个时间相差多少天还能计算星期,小时等等~~看看帮助吧~~
sqlstr:='select sum(cost),sum(datediff(hour,starttime-endtime)) from checkb where (typeno='+''''+typeno+''')and(starttime>'''+datetimetostr(datetimepicker1.datetime)+''')and(endtime<'''+datetimetostr(datetimepicker2.datetime)+''')';
急!!!急!!!
select *,datediff(day,csr,j) as jzs from jz
请帮帮我,现在急需!!!
谢谢
可能也不支持CONVERT?
现在叫我怎么办
真气人!!!!