In MySQL, dates are complicated.
while working with database, the format of the date in table must be matched.
SQL SELECT DATE is used to retrieve a date from a database.
SQL Server comes with the following data types for storing a date or a date/time value in the database
Now we want to select the records with a Date of "2008-11-11" from table .
we use the following SELECT statement:
SELECT * FROM 'table_name' WHERE Date='2008-11-11'
If the value of the date format is like 'YYYY-MM-DD' we can retrive a result.
But if the value of the date format is other format like 'YYYY-MM-DD HH:MI:SS' we will get no result! This is because the query is looking only for dates with no time portion
To keep your queries simple and easy to maintain, do not allow time components in your dates!