I don’t often use SQL queries but sometimes I have to. And every time it’s the same – I use search engines to find documentation, especially about work with datetime fields. During these readings I found out at least 3 ways to select records with date I need.

The task is to get records about employees who were born in September 1990.

1. The first way is using BETWEEN:

 

2. Using function DATEPART – it has a lot of parameters, but the condition is some longer.

 

3. Using CONVERT function:

 

Which of them to choose - I advice you to see a plan of request and make a decision after.