L loxtln Unregistered / Unconfirmed GUEST, unregistred user! 2002-09-03 #1 条件查询一个DBASE库时,如何查询某月某日(年份任意)的记录?SQL该如何写?
J jsxjd Unregistered / Unconfirmed GUEST, unregistred user! 2002-09-03 #2 ... where month(fieldName)=10 and day(fieldname)=12
Q QuickSilver Unregistered / Unconfirmed GUEST, unregistred user! 2002-09-03 #3 select * from tablename where EXTRACT(YEAR FROM rq)=2002 and EXTRACT(month FROM rq)=9 and EXTRACT(day FROM rq)=3
select * from tablename where EXTRACT(YEAR FROM rq)=2002 and EXTRACT(month FROM rq)=9 and EXTRACT(day FROM rq)=3
T twos Unregistered / Unconfirmed GUEST, unregistred user! 2002-09-03 #5 入QuickSilver所述,只要是通过BDE访问,Paradox以及DBase等应该都支持这个的