CODEWITHSUNDEEP
sql-serverssms-16
Real Gem
Real Gem

Reputation: 49

How to fetch values from starting of the year in MS SQL

I can get exact 3 years of value with the below code (from 01/24/2018 - 01/25/2021)

select * from datamining.dbo.EmployeeDetails
where DateOfjoining >= DATEADD(year,-3,GETDATE())

But I'm expecting the results should be from 01/01/2018 - 01/25/2021(Till date)

How do I achieve this?

Upvotes: 0

Views: 101

Answers (1)

David Browne - Microsoft
David Browne - Microsoft

Reputation: 89091

Lots of ways. One is to combine YEAR, which extracts the numeric year value from a date and DATEFROMPARTS, which constructs a date from Year, Month, and Day componenets. EG:

select * from datamining.dbo.EmployeeDetails
where DateOfjoining >= DATEFROMPARTS(YEAR(DATEADD(year,-3,GETDATE())),1,1)

Upvotes: 1

Related Questions