How to find records with minutes range.

Hi Experts,

I need to find records with following ranges.

18 Nov 2009 10:00:00 to 19 Nov 2008 10:00:00.

could you please suggest me the sql.

Thanks in advance.

where date_column between 18 Nov 2008 10:00:00 and 19 Nov 2008 10:00:00

where start_date between to_date('18-NOV-08 10:00:00','DD-MON-YY HH24:MI:SS') and to_date('19-NOV-08 10:00:00','DD-MON-YY HH24:MI:SS')

select * from Table Name where date_column between 18 Nov 2008 10:00:00 and 19 Nov 2008 10:00:00

Quote:

---

Originally Posted by nisarg

select * from Table Name where date_column between 18 Nov 2008 10:00:00 and 19 Nov 2008 10:00:00

---

why have you posted what 2 others have already done