between and 方法
- select * from kk.kkhmd where larq between(to_date('2008-9-3','yyyy-mm-dd')) and (to_date('2008-9-5','yyyy-mm-dd'))
用and连接 >= <= 方法
- select * from kk.kkhmd where larq>=to_date('2008-9-3','yyyy-mm-dd') and larq <=to_date('2008-9-5','yyyy-mm-dd')
转载至：http://heisetoufa.iteye.com/blog/239718