DateTimePicker的时间在query1(sql)语句中怎么写？

Question

select * from database where time>'datetimepicker.date'
这样写对吗？

Answer 1

肯定不对！！
select * from database where time>‘“+'datetimepicker.date'+”’

Answer 2

......select * from database where time>:Date
......PARAMBYNAME('Date')='datetimepicker.date'

Answer 3

select * from database where time>:Date
PARAMBYNAME('Date').AsDatetime:=datetimepicker.date;//用参数赋值更好一些

Answer 4

query.sql.add('select * from database where time>'''+DateTimeToStr(datetimepicker.date)+'''')

Answer 5

query1.sql.text:='select * from tablename where time>"'+datetimetostr(datetimepicker.datetime)+'"'