Records between 2 dates

[Zajil]

Hi,

I am using php to read from database with ODBC connection, this database has a table called "requests" this table has a date column called "req_date", I need a sql statement that return all records that between two dates.

Note that the date column is in Date Type.

Thank you.

[Lars_Berg]

Which DBMS?

select * from requests where req_date between date '2002-02-22' and date '2002-04-23'

That's one way but many DBMS have their own way of specifying date literals.

e.g. Jet SQL

select * from requests where req_date between #02/22/2002# and #04/23/2002#

[Zajil]

Thanks Lars Berg,

I will try it 🙂