In this example, I’ll show you How to List students whose birth date is today.
|
1 2 3 4 5 |
Select * from students where MONTH(birthdate) = MONTH(getdate()) and Day(birthdate) = Day(getdate()) |
Result:
SQL Query to Select Records From a Table if the Birthdate is Today
Result:
