Good. As you saw, dates are shown in the following format, which is the default SQL Server format:
First we have the year, then the month, and finally the day. Be aware, though, that SQL Server has other date formats as well. We'll discuss how to change the default date format later in this course.
DATE data type in SQL Server has a range of
9999-12-31. The default value for this data type is
If we want to use dates in our queries, we need to enclose them with single quotes, like this:
WHERE ProducedDate = '2012-04-05';
This query will return the ID and model numbers for all aircraft produced on April 5, 2012.