select * from YouTable where 生日=[1982-2-2] select * from youtable where 生日 between [1980-1-1] and [1995-1-1]
另外一点要注意:between ... and ... 是包含两个端点的
Query.sql.text:='select * from YouTable where 生日='''+datetimetostr(datetimepicker1.datetime)+'''';Query.sql.text:='select * from youtable where 生日 between '''+ datetimetostr(datetimepicker1.datetime)+''''+' and '''+datetimetostr(datetimepicker2.datetime)+'''';
'select * from YouTable where 生日>='''+datetimetostr(datetimepicker1.datetime)+'and 生日 <='''+datetimetostr(datetimepicker2.datetime)+'''';
select * from youtable where 生日 between [1980-1-1] and [1995-1-1]
是包含两个端点的
datetimetostr(datetimepicker1.datetime)+''''+' and '''+datetimetostr(datetimepicker2.datetime)+'''';