S sunyat Unregistered / Unconfirmed GUEST, unregistred user! 2006-09-12 #1 在表中我有一字段 dwc 是varchar类型，但保存的是日期，格式为yyyy-mm-dd, 请问在Sql语句中怎么实现Select * From 表 where dwc < 日期型值
X xiaoyue_a Unregistered / Unconfirmed GUEST, unregistred user! 2006-09-12 #2 Select * From 表 where convert(datetime,dwc) < convert(datetime,'2006-09-10')
D dcs_dcs Unregistered / Unconfirmed GUEST, unregistred user! 2006-09-12 #3 Select * From 表 where cast(dwc as datetime) < convert(datetime,'2006-09-10')
H hityou Unregistered / Unconfirmed GUEST, unregistred user! 2006-09-12 #4 如果时sqlserver不需要转换，默认会转的 直接查询即可 select * from table where field > 日期型值
B bmsr Unregistered / Unconfirmed GUEST, unregistred user! 2006-09-12 #6 http://www.delphibbs.com/delphibbs/dispq.asp?lid=3536650 不同数据库参看此帖
G gaobangsheng Unregistered / Unconfirmed GUEST, unregistred user! 2006-09-12 #7 Select * From 表 where dwc < convert(varchar(10),'2006-09-10',121) 我这才是最正确的
W wrl_001 Unregistered / Unconfirmed GUEST, unregistred user! 2006-09-12 #9 sql.text:='select * from table where field >='''+ DateToStr(Date) +''''; 或者用参数传入方式 sql.text:='select * from table where field >=:Field1'; parambyname('field1').value:=Date;
sql.text:='select * from table where field >='''+ DateToStr(Date) +''''; 或者用参数传入方式 sql.text:='select * from table where field >=:Field1'; parambyname('field1').value:=Date;
