Can anyone tell me How to Write a SQL Query to get all people born on Yesterday?

Last Post

RSS

Posts: 47

Pavan NJ

Guest

Topic starter

Jul 28, 2020 6:57 am

(@Pavan NJ)

Eminent Member

Joined: 4 years ago

How to achieve this SQL Query to get all people born on Yesterday

Topic Tags

sqlpeoplebornonyesterday

1 Reply

Posts: 36

Sandeep0069

Guest

Jul 28, 2020 10:42 am

(@Sandeep0069)

Eminent Member

Joined: 4 years ago

Let us do some workaround to achieve this.

Select (GETDATE) Will give us the current Date with the timestamp

To Avoid timestamp we can use CAST Function

Select CAST(GETDATE() as Date) will give us the date without a timestamp.

Final Query Query

Select DATEADD(Day,-1,CAST(GETDATE() as Date)) as [Datepart]

From Employees

Where CAST(DateOfBirth as Date) = DateADD(Day,-1, CAST(GETDATE() as DATE)