How to get only part of the date when using dateadd () and getdate ()

Question

I want to display records for the last 4 months from the current date.

I do not want to consider time

How can I get only a part of the date from the query below?

where OrderDate >= DATEADD(month, -4, GETDATE())

+3

Challa jyothi Feb 25 '14 at 10:01

3 answers

If you are using SQL Server 2008, try converting GETDATE()to DATEdirectly.

WHERE OrderDate >= DATEADD(month, -4, CONVERT(date, GETDATE()))

+4

Darren davies Feb 25 '14 at 10:05

DATE, : DATETIME CHAR, DATETIME, :

SELECT CONVERT(DATETIME, CONVERT(CHAR(8), GETDATE(), 112), 112)
-- -----------------------
-- 2014-02-25 00:00:00.000

( ), .

0

Gerardo Lima Feb 25 '14 at 10:42

Hitesh · Accepted Answer · 2014-02-25T10:16:34+0000

Why not use the simple DATEDIFF function

where DATEDIFF(MM, OrderDate, GETDATE()) < 4