为什么我这个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 字段是日期类型
\还是把时间类型通同不要
只要CHAR类型
select personnerid,makeid,workid,price
from dbo.countmakeid where gzdate BETWEEN '2003-1-18' and '2003-1-19'