SQLServer date format

I always have problems with the date format for various databases.

Here is a date format that works with SQL Server

SELECT * FROM DateSample
WHERE DateVal = ‘2002-02-28’