TimeBegin := DateToStr(DateTimePicker1.Date)+' '+TimeToStr(DateTimePicker2.Time);
TimeEnd := DateToStr(DateTimePicker3.Date)+' '+TimeToStr(DateTimePicker4.Time);
//将历史追忆的选项发送到ADODataSet的comandText
ADODataSet1.CommandText:= 'use Historydb Select * From historyalarmanalog '
+'where Alarmtime between '
+''''+TimeBegin+''''+' AND '+'''' + TimeEnd+'''';
使用这条查询语句,怎么也检索不到数据,在这个时间段里,应该有两条记录的。而使用Select top 1 * from historyalarmanalog却能正常检索到第一条记录。请问原因在哪里?
TimeEnd := DateToStr(DateTimePicker3.Date)+' '+TimeToStr(DateTimePicker4.Time);
//将历史追忆的选项发送到ADODataSet的comandText
ADODataSet1.CommandText:= 'use Historydb Select * From historyalarmanalog '
+'where Alarmtime between '
+''''+TimeBegin+''''+' AND '+'''' + TimeEnd+'''';
使用这条查询语句,怎么也检索不到数据,在这个时间段里,应该有两条记录的。而使用Select top 1 * from historyalarmanalog却能正常检索到第一条记录。请问原因在哪里?
+'where Alarmtime between '
+'''+TimeBegin+''' AND ''' + TimeEnd+'''';
谢谢,还是不行呀。
原因是在SQL server2000中日期格式 2007-07-13 20:32:06 和2007-7-13 20:32:06表示不同的含义