How I make a query in SQL Server using a field of the type date?

Example: SELECT * FROM Customer WHERE Birth = ' 01/01/1982 '

I must use quotes marks same, or exists some another separator for the field of the type date?

This post has been edited by microscopic^earthling: Aug 28 2005, 02:53 AM

What you have shown


is a perfectly valid SQL query that tells the server to retrieve all people from the customer table whose birthday was on 01/01/1982, if there were none that met that criteria then the response would be blank or null becuse no record was found that met the criteria, just for the fun of it to make sure your syntax is right do this



and it will return all customers just as if you did a


then you could also do this for age verification of those at least 22 years old by

And also, look what is your database, by simply writing
select Birth from customer ;
this will tell you all the birth dates in your database, and you will see whether you had blanks, or wich format your customers used.
this is not very different from "select * from customer", but will give you only the Birth column, this should be nicer for diagnostics.