How to Write a SQL Query to get all people born on given dates?

Last Post

RSS

Posts: 47

Rakesh

Guest

Topic starter

Jul 28, 2020 3:48 am

(@Rakesh)

Eminent Member

Joined: 4 years ago

Dates are given here 01-Jan-2019 and 31-Dec-2019

Topic Tags

peoplebornongivendates sqlquerypeopleborn

1 Reply

Posts: 36

Sandeep0069

Guest

Jul 28, 2020 10:48 am

(@Sandeep0069)

Eminent Member

Joined: 4 years ago

Use the date between function to achieve this.

Select Name, DateOfBirth, CAST(DateOfBirth as Date) as [DatePart]

From Employees

Where CAST(DateOfBirth) Between '2019-01-01' AND '2019-12-31'