一个sql问题

[amartapple]

access数据库中一个字段为 日期/时间 类型

sql语句为:
DateTime TodayDate = DateTime.Now.Date;
select id,name from person where brith=TodayDate order by brith desc"

编译通过,运行出现运行时错误

[lamcoo]

select id,name from person where brith=Convert(datetime,TodayDate) order by brith desc

[lamcoo]

string strStart = DateTime.Now.toString("yyyyMMdd ")+"00:00:00";
string strEnd = DateTime.Now.toString("yyyyMMdd ")+"29:59:59";

execSql("select id,name from person where brith>'"+strStart+"' and brith<'"+strEnd+"' order by brith desc")

[lamcoo]

键盘有点坏，上面的29：59：59 应为： 23:59:59

[nedvedlh]

时不是你的字段类型不一致啊！本身语句没有问题！

[amartapple]

是呀,数据库中是时间/日期型,比如:2002-5-26
这中类型怎么在sql中用

[kuangren]

时间用''引着～

[clzhx]

同意 lamcoo(烟虫)

[canyqf]

access里面好像日期型的要用#代替'

[amartapple]

数据库中只有日期,没有时间
请写出sql语句,我试验一下

[wueg2003]

brith=TodayDate 出错啦

[tianxia1]

DateTime TodayDate = DateTime.Now.Date.ToShortDateString();
String strSql = "select id,name from person where brith=#"+TodayDate+"# order by brith desc"

[tianxia1]

String TodayDate = DateTime.Now.Date.ToShortDateString();
String strSql = "select id,name from person where brith=#"+TodayDate+"# order by brith desc"

[amartapple]

问题解决,谢谢大家