use to_date,to_char to do this: select * from tab1 where to_char(reg_date,'yyyymmdd') between '20020101' and '20030101'
最好不要在where中包含to_char 效率很低
select * from nls_session_parameters --->Please check NLS_DATE_FORMAT for example : NLS_DATE_FORMAT = 'DD-MON-YYYY'Then you can do like SELECT * FROM BDAYCLUB.BC_USER WHERE (REGISTRATION_DATE BETWEEN "12-FEB-2003" AND "15-FEB-2003")
select * from tab1 where to_char(reg_date,'yyyymmdd') between
'20020101' and '20030101'
效率很低
for example : NLS_DATE_FORMAT = 'DD-MON-YYYY'Then you can do like
SELECT * FROM BDAYCLUB.BC_USER
WHERE (REGISTRATION_DATE BETWEEN "12-FEB-2003" AND "15-FEB-2003")
我觉得penitent(只取一瓢) 的方法最好结贴