SQL Query to Select Records From a Table if the Birthdate is Tomorrow

5 years ago

[jp_post_view]

In this post, I’ll show yo How to List students whose birth date is tomorrow in SQL table.


Select * from students 
where MONTH(birthdate) = MONTH(dateadd(dd,1,getdate())) 
and Day(birthdate) = Day(dateadd(dd,1,getdate()))

Select * from students

where MONTH(birthdate) = MONTH(dateadd(dd,1,getdate()))

and Day(birthdate) = Day(dateadd(dd,1,getdate()))

Result: