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