C#,Windows Form, WPF, LINQ, Entity Framework Examples and Codes

SQL

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

5 years ago

Add Comment

by admin

[jp_post_view]

In this post,I’ll show yo How to List students whose birth date is in next week.

SQL Query:


Select * from students where 
datepart(dy,birthdate) between datepart(dy,dateadd(dd,1,getdate())) and datepart(dy,dateadd(dd,7,getdate()))
order by month(birthdate),day(birthdate)

Select * from students where

datepart(dy,birthdate) between datepart(dy,dateadd(dd,1,getdate())) and datepart(dy,dateadd(dd,7,getdate()))

order by month(birthdate),day(birthdate)

Result:

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

Like this:

Leave a Comment X

Like this:

You may also like

Leave a Comment X