SELECT *
FROM tab_name
WHERE to_char(field_date,'DD/MM/YYYY') between '12/12/2004' and '20/12/2004'
And to_char(field_date,'HH24') between '10' and '12';
FROM tab_name
WHERE to_char(field_date,'DD/MM/YYYY') between '12/12/2004' and '20/12/2004'
And to_char(field_date,'HH24') between '10' and '12';
或log miner