delphi(0分)

temp :='select * from user_loginlog '+
' where '''+datetostr(uptime)+''' between '''+datetimetostr(datetimepicker1.Date)+''' and '''+datetimetostr(datetimepicker2.Date)+'''';
其中uptime为user_loginlog表中的一个字段,数据类型为日期/时间型.
程序运行错误提示为: datetostr未定义.

Temp := 'SELECT * FROM user_loginlog WHERE 字段名 BETWEEN ''' + DateTimeToStr(DateTimePicker1.Date) + ''' AND '''+ DateTimeToStr(DateTimePicker2.Date) + ''''

Temp := 'SELECT * FROM user_loginlog WHERE uptime BETWEEN ''' + DateTimeToStr(DateTimePicker1.Date) + ''' AND '''+ DateTimeToStr(DateTimePicker2.Date) + ''''
因为引用的是字段名，不是值

select * from 表名 where 字段名 between x1 and x2