PLSQL,其中日期时间在一个日期范围内

使用 TO_DATE function :

WHERE date_column BETWEEN TO_DATE(start, 'MM/DD/YYYY')
                      AND TO_DATE(end, 'MM/DD/YYYY')

试试这个,

SELECT * FROM table WHERE date BETWEEN to_date('01/05/2010','mm/dd/yyyy') AND to_date('10/01/2010','mm/dd/yyyy') ORDER BY date ASC