Re: A Question - Mailing list pgsql-sql

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