SQL 日期 年月日的问题,求助大家!谢谢!

[rambolxd]

m_dBeginDate="2008-8-11"
m_dFinishDate="2008-8-11"

sSql="SELECT sum(case when isnumeric(PerScore)=1 then cast(PerScore as float) else 0 end) as PerScore,sum(case when isnumeric(PerModify)=1 then cast(PerModify as float) else 0 end) as PerModify,count(*) as num FROM TelephoneNote WHERE Recorder='方岳龙' AND LastFinishedTime>='"&m_dBeginDate&"' AND LastFinishedTime<='"&m_dFinishDate&"' AND Finished='True' AND (PerCheck='True' OR PerModify='') AND (ProductType in (SELECT ProductType FROM Com_product_type WHERE SystemType='relay'))"

LastFinishedTime的格式是2008-8-11 9:56:33
LastFinishedTime>='"&m_dBeginDate&"' AND LastFinishedTime<='"&m_dFinishDate&"' 如此这个条件就不能满足
我想请教LastFinishedTime从SQL中怎么只读日期的那部分,而不要读时分秒!对LastFinishedTime这个字段采用什么方法或格式????

[zds1010]

昏，你找到才怪了呢？你看看条件啊~~~
我感觉你的意思就是查找那天的数据是不是啊
那你为什么改变数据库的数据啊~~~
where 开始字段>=输入的那个数值 and 截至字段<=输入的那个数值+' 23:59:59'
不是结果都一样吗》》》》

[zds1010]

convert(varchar(10),LastFinishedTime,20)出来格式就是：2008-8-10

http://www.xpeng.com.cn
http://www.lyyywx.com.cn
http://www.bdgxqsq.com.cn

[rambolxd]

你的意思是用convert(varchar(10),LastFinishedTime,20)在语句里直接替换LastFinishedTime?????

sSql="SELECT sum(case when isnumeric(PerScore)=1 then cast(PerScore as float) else 0 end) as PerScore,sum(case when isnumeric(PerModify)=1 then cast(PerModify as float) else 0 end) as PerModify,count(*) as num FROM TelephoneNote WHERE Recorder='李春雪' AND convert(varchar(10),LastFinishedTime,20)>='"&m_dBeginDate&"' AND convert(varchar(10),LastFinishedTime,20)<'"&m_dFinishDate&"' AND Finished='True' AND (PerCheck='True' OR PerModify='') AND (ProductType in (SELECT ProductType FROM Com_product_type WHERE SystemType='relay'))"
刚才试过了,为什么还是不行,找不到记录,但数据库里满足条件的有很多,还请赐教!

[齐天大圣etln]

可以 先把数据格式转为 2008-08-01 这样 然后 用left 函数 做

[hyqwan11112]

直接用convert函数即可
select convert(varchar(10),getdate(),120)
select convert(varchar(10),getdate(),112)