where UNIX_TIMESTAMP(时间字段) >起时间段的unix时间戳 and UNIX_TIMESTAMP(时间字段)<止时间字段的unix时间戳.起止时间戳即可以事先生成好整型数值,也可以直接在SQL里用unix_timestame生成.如UNIX_TIMESTAMP('2008-01-01')
顺便问一下,谁有过将time()送进access中的时间字段的经验?
select m.jointime, mp.* from #@__member_perinfo mp left join #@__member m on mp.id=m.ID where m.type=0 and mp.usertype=2 and mp.truename <>"" and m.sex like '%%' And DATE_FORMAT(mp.qz_biyeshijian, '%Y') = 2005 order by mp.id desc 把问题复杂化了,呵呵!
DATE_FORMAT(xxx, '%k') > 8 and DATE_FORMAT(xxx, '%k') < 13
这样看起来不会那么乱
select m.jointime, mp.* from #@__member_perinfo mp left join #@__member m on mp.id=m.ID where m.type=0 and mp.usertype=2 and mp.truename <>"" and m.sex like '%%' And DATE_FORMAT(mp.qz_biyeshijian, '%Y') = 2005 order by mp.id desc 把问题复杂化了,呵呵!
DATE_FORMAT(xxx, '%k') > 8 and DATE_FORMAT(xxx, '%k') < 13