select t.*, t.rowid from t_sal_process t where to_date(t.last_update_date, 'YYYY-mm-dd hh24:mi:ss') between to_date('2010-01-01 00:00:00','YYYY-mm-dd hh24:mi:ss') and to_date('2011-05-01 00:00:00','YYYY-mm-dd hh24:mi:ss')
调试欢乐多
--如果是varchar2等类型才需要to_date
SELECT t.*, t.rowid
FROM t_sal_process t
WHERE t.last_update_date BETWEEN
to_date('2010-01-01 00:00:00', 'YYYY-mm-dd hh24:mi:ss') AND
to_date('2011-05-01 00:00:00', 'YYYY-mm-dd hh24:mi:ss')