select * from tbl_contact e where e.dob between to_date('26-APR-2000','DD-MON-YEAR') and to_date('03-MAY-2002','DD-MON-YEAR')
如何解决此问题。
如果表的dob字段类型是date,则以下查询将为您提供帮助:
select * from tbl_contact e where e.dob between
to_date('26-APR','DD-MON') and to_date('03-MAY','DD-MON')
希望对您有所帮助