sql query for date code example

Example: sql query for date

SELECT * FROM Orders WHERE OrderDate='2008-11-11'