Select records of up coming birthday within 3 days in SQL Server

Question

pls help in sql query to find out whose birthday coming in within 3 days means today tomorrow and day after tomorrowlike today date is 29042022 and dateof birth is 01052022DOB format is ddMMyyyy

dharmendr · Accepted Answer

Use Where condition as below SELECT EmployeeId FirstName LastNameFROM Employees AS DaysDifferenceWHERE DATEDIFFDAY CAST390429202239 AS DATE CAST390501202239 AS DATE BETWEEN 1 AND 3

Select records of up coming birthday within 3 days in SQL Server

Company

Explore

Follow us

Contact Us