SQL查询语句语法错误，找不出来！请教高手！

[benbenRH]

string cmdText = "select attentiontime, nickname, message from message,person where attentiontime>=" + DateTime.Now + " and attentiontime=<" + DateTime.Now.AddDays(1) + " and message.personid=person.id";

语法错误：
where attentiontime>=" + DateTime.Now + " and attentiontime=<" + DateTime.Now.AddDays(1) + " and message.personid=person.id";

[lixinramaxel41658133]

改成:
where attentiontime>='" + DateTime.Now.ToString() + "' and attentiontime<='" + DateTime.Now.AddDays(1).ToString() + "' and message.personid=person.id";
试一试

[gw_tong]

DateTime.Now
改成=>DateTime.Now.ToString（strFormat）
试试看

[huangzhe10]

attentiontime= <
有这样的写法？？！？！

[benbenRH]

[Quote=引用 1 楼 lixinramaxel41658133 的回复:]
改成:
where attentiontime>='" + DateTime.Now.ToString() + "' and attentiontime <='" + DateTime.Now.AddDays(1).ToString() + "' and message.personid=person.id";
试一试
[/Quote]
[Quote=引用 2 楼 gw_tong 的回复:]
DateTime.Now
改成=>DateTime.Now.ToString（strFormat）
试试看

[/Quote]
两种方法都不行！

[benbenRH]

[Quote=引用 3 楼 huangzhe10 的回复:]
attentiontime= <
有这样的写法？？！？！
[/Quote]

呵呵，给你看出来了，就是>= 写成了=>，这个出错了！谢谢各位