以下SQL语句为什么不行呢:
select * from PlaneSell where true and RideDate between #2005-12-08 00:00:00# and #2005-12-08 23:59:59# order by id以下SQL语句又可以:
select * from PlaneSell where true and RideDate between #2005-12-08# and #2005-12-08# order by id怎么回事呢?????
select * from PlaneSell where true and RideDate between #2005-12-08 00:00:00# and #2005-12-08 23:59:59# order by id以下SQL语句又可以:
select * from PlaneSell where true and RideDate between #2005-12-08# and #2005-12-08# order by id怎么回事呢?????
aa:='bmrq >=to_date('+''''+ FormatDateTime('yyyy-mm-dd',EncodeDate(YearOf(StrToDate(bmrq.text)),MonthOf(StrToDate(bmrq.text)),DayOf(StrToDate(bmrq.text)))+CypxBmCyc)+''''+','+'''yyyy.mm.dd'''+') and bmrq <=to_date('+''''+ FormatDateTime('yyyy-mm-dd',EncodeDate(YearOf(StrToDate(bmrq.text)),MonthOf(StrToDate(bmrq.text)),DayOf(StrToDate(bmrq.text)))) +''''+','+'''yyyy.mm.dd'''+')';