SQL 92 answer.
Re: How do i create a query to extract all records within a given date. For instance beginning date and?
[sql]
select * from t where d between date('2002-01-01') and date('2003-01-01');
[/sql]
or using intervals:
[sql]
select * from t where d between date('2002-01-01') and date('2002-01-01')+interval 10 month;
[/sql]
|