有这样一段代码:
'select * from buymachine where date<='+''''+maskedit1.text+''''
maskedit1.text输入的是2002-11
而date字段的值是2002-11-12
我怎样有语句把让date字段的值与maskedit1.text 的值匹配????
谢谢大家拉!!!!!!
'select * from buymachine where date<='+''''+maskedit1.text+''''
maskedit1.text输入的是2002-11
而date字段的值是2002-11-12
我怎样有语句把让date字段的值与maskedit1.text 的值匹配????
谢谢大家拉!!!!!!
就可以了
'select * from buymachine where Year(date) < ' + Copy(MaskEdit1.Text, 1, 4) + ' or Year(date) = ' + Copy(MaskEdit1.Text, 1, 4) + ' and Month(date) <= ' + Copy(MaskEdit1.Text, 6, 2)
日期>=StrToDate(maskedit1.text+'-01');
日期<StrToDate(maskedit1.text+'-01')+DaysInAMonth(本月)
上述方法具体用法查帮助
select * from employee where leave_start>='+''''+datetostr(datetimepicker1.date)+''''+'and leave_state<='+''''+datetostr(datetimepicker2.date)+'''');
//years and months is word
//dates is string
years:=yearof(strtodate(maskedit1.text+'-01'));
months:=monthof(strtodate(maskedit1.text+'-01'));
dates:=inttostr(years*12+months);
select * from emploayee where year(date)*12+month(date)<='+''''+dates+'''';
不妨试试!!