Jul 28, 2020 6:55 am
Any year like 2019 or 2020.
I want to capture all people whose birth yer is the same from a table. Consider employee table.
1 Reply
Jul 28, 2020 11:01 am
I choose in 2019 . You can also use In List to get both the year's data.
Select Name, DateOfBirth, CAST(DateOfBirth as Date) as [DatePart]
From Employees
where Year(DateOfBirth)='2019'