关于SQL SERVER中,查找指定日期记录的问题!!(20分)

R

royhgf

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2008-08-24

• #1

我用的是MA SQL SERVER数据库,其中一个字段为日期类型,我想要程序中实现查找ComboBox中选择年份.请给一个简单的例子.我已经把Vyear := ComboBox.text<br>'select * from Ts where 所属分局 like ''%'+VFj+'%'' and 所属中队 like ''%'+VTeam+'%'' and year(接收日期)=''+Vyear+'''出错...

 

S

szhcracker

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2008-08-24

• #2

我不大清楚MA SQL SERVER数据库的函数，不过你应该用一个函数截取那个字段的“年”的部分来与你的变量进行比较，类似于FormatdateTime('yyyy', fieldyear) = Vyear。

 

Z

zylsoft

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2008-08-24

• #3

'select * from Ts where 所属分局 like '+#39+'%VFJ%'+#39+' and 所属中队 like '+#39+'%VTeam%'+#39+' and year(接收日期)='+ #39+'+Vyear+@29

 

Z

zylsoft

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2008-08-24

• #4

'select * from Ts where 所属分局 like '+#39+'%VFJ%'+#39+' and 所属中队 like '+#39+'%VTeam%'+#39+' and year(接收日期)=' + #39+'+Vyear+@29<br><br>试下这个

 

Z

zylsoft

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2008-08-24

• #5

'select * from Ts where 所属分局 like '+#39+'%VFJ%'+#39+' and 所属中队 like '+#39+'%VTeam%'+#39+' and year(接收日期)=' + #39+'+Vyear+@29

 

R

royhgf

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2008-08-24

• #6

所属分局 like ''%'+VFj+'%'' and 所属中队 like ''%'+VTeam+'%'' &nbsp;这部分是没有错的,只是 and year(接收日期)=''+Vyear+'''出错... &nbsp;<br><br>试过来自：zylsoft, 时间：2008-8-24 19:53:08, ID：3916268<br>'select * from Ts where 所属分局 like '+#39+'%VFJ%'+#39+' and 所属中队 like '+#39+'%VTeam%'+#39+' and year(接收日期)=' + #39+'+Vyear+@29 &nbsp;<br>不行

 

D

david_wu

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2008-08-25

• #7

'.... and year(接收日期)='+Vyear

 

F

fhli

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2008-08-25

• #8

where convert(int, convert(varchar(8),getdate(),112)) = 20080808

 

B

bluet

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2008-08-25

• #9

查看数据库是的日期字段是否多了 时分秒等...<br>在你的选择查询时只选到了日期 &nbsp;比如2008-8-8 <br>查询时应该为 time &gt;=2008-8-8 and time &lt; 2008-8-9