sql query isuue

[Manik]

What is difference in this query

SELECT * FROM Orders
WHERE OrderDate BETWEEN #01/07/1996# AND #31/07/1996#;

and

SELECT * FROM Orders
WHERE OrderDate BETWEEN '1996-07-01' AND '1996-07-31';

please explain in details

[justsomeguy]

They use different formats for dates.