1. select * from table where to_char(datefield,'YYYYMMDD') between '20020101' and '20021231' ;2. select * from table where to_char(datefield,'YYYY年MM月DD日') between '2002年01月01日' and '2002年12月31日' ;1.is quickly than 2.
select to_char(date,'yyyy"年"mm"月"dd"日"hh24"时"mi"分"ss"秒"') from table where to_char(date,'yyyy"年"mm"月"dd"日"') between '2002年06月04日' and '2002年06月05日'
select * from table where to_char(datefield,'YYYYMMDD')
between '20020101' and '20021231' ;2.
select * from table where to_char(datefield,'YYYY年MM月DD日')
between '2002年01月01日' and '2002年12月31日' ;1.is quickly than 2.
from table
where to_char(date,'yyyy"年"mm"月"dd"日"') between '2002年06月04日' and '2002年06月05日'