为什么我这个SQL语句在查询分析器上没有数据得出
select personnerid,makeid,workid,price
from dbo.countmakeid where gzdate BETWEEN 2003-1-18 and 2003-1-19//gzdate 字段是日期类型
select personnerid,makeid,workid,price
from dbo.countmakeid where gzdate BETWEEN 2003-1-18 and 2003-1-19//gzdate 字段是日期类型
select personnerid,makeid,workid,price
from dbo.countmakeid where gzdate BETWEEN '2003-1-18' and '2003-1-19'
我的时间类型不是CHAR
怎么要加单引号的
'2003-1-18' and '2003-1-19'//这是SQLSERVER的用法
#2003-1-18#//这是在ACCESS里
from dbo.countmakeid where gzdate BETWEEN '2003-1-18' and '2003-1-19'建议select personnerid,makeid,workid,price
from dbo.countmakeid where '2003-1-18'<gzdate and gzdate>'2003-1-19'