select dddd date, ......
from ...
where date>to_date('2002-02-02','YYYY-MM-DD')
and date<to_date('2002-07-10','YYYY-MM-DD')
from ...
where date>to_date('2002-02-02','YYYY-MM-DD')
and date<to_date('2002-07-10','YYYY-MM-DD')
where to_char(日期型字段,'YYYY.MM.DD')>='2002.02.02'
and to_char(日期型字段,'YYYY.MM.DD')<='2002.07.10';
from ...
where to_char(日期字段,'YYYY-MM-DD')>='2002-02-02'
and to_char(日期字段,'YYYY-MM-DD')<='2002-07-10'