Thread: A Question

Hi, my name is sherril .I have the following Question
My one feild in the database is Date/time  I want  to find a range of 
records which exists between two dates in  the same date field in the 
database
Also tell me how to retreive  all records from database where field which is 
date time is null I am working on ASP and backend as ms-ACCESS
My email Address is m_sherril@hotmail.com
________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com

On Fri, 26 May 2000, Sherril Mathew wrote:

> My one feild in the database is Date/time  I want  to find a range of 
> records which exists between two dates in  the same date field in the 
> database

SELECT * FROM table WHERE datetime_field between '1999-03-15' and
'2000-10-23';

> Also tell me how to retreive  all records from database where field which is 
> date time is null I am working on ASP and backend as ms-ACCESS

SELECT * FROM table WHERE datetime_field is null;


-- 
Peter Eisentraut                  Sernanders väg 10:115
peter_e@gmx.net                   75262 Uppsala
http://yi.org/peter-e/            Sweden