|
#2
madpbpl2007-08-31 19:00
|
我想比较时间用到的时间比较函数，大家都说要格式应该是 member_birth>=#1987-8-31#
我写的语句是 member_birth>="&nianlinga&" and member_birth<="&nianlingb&"
输出为：
select * from member where member_birth>=1987-8-31 and member_birth<=1977-8-31 and member_flag=1 order by member_reg asc
但是我想输出为：
select * from member where member_birth>=#1987-8-31# and member_birth<=#1977-8-31# and member_flag=1 order by member_reg asc
改怎么写sql语句那 我对where条后后面一堆逗号，引号看不懂，不知道该怎么弄！