SELECT * FROM Fee_Main WHERE cCode<>'散客' and ddate>='2003-8-21' and ddate<='2003-8-21' and dtime>='00:00:00' and dtime<='23:59:59'
为何查询不到数据
数据库dTime是Datatime型
请赐教,
...全文
3817打赏收藏
在线等待!SQL 查询语句的问题
SELECT * FROM Fee_Main WHERE cCode'散客' and ddate>='2003-8-21' and ddate='00:00:00' and dtime<='23:59:59' 为何查询不到数据 数据库dTime是Datatime型 请赐教,
比照这个写就可以了。
dim snpjc As New ADODB.Recordset
s = "select * from 档案 where id = " & Val(Key) & " and 日期 >= convert(snp("更改日期"), " & Format(CVDate(rq), "MM-dd-yyyy hh:mm") & "',102) and 日期 <= convert(datetime,'" & Format(snp("更改日期"), "MM-dd-yyyy hh:mm") & "',102) order by 日期"
snpjc.Open s, cn
ddate是Datetime型,'2003-8-21'其实是'2003-8-21 00:00:00',是一个时间点,不是对应一天的时间,所以,你改成这样看看:
SELECT * FROM Fee_Main WHERE cCode<>'散客' and ddate>='2003-8-21' and ddate<='2003-8-22'