Simple SQL Query: need this month data and previous month last 5 days data together

Question

Need SQL query for this month data and previous month last 5 days data together:

SELECT
  CONVERT(VARCHAR (10), wDate, 103) AS wDate,
  Empid,
  Process,
  Model,
  Qty,
  Section,
  Avlbl_Mins,
  NP_Mins,
  L_Mins,
  NP_Reason       AS NPReason,
  Process_Remarks AS PRem,
  Day_Remarks     AS DRem,
  Othermin,
  StdMin,
  Tstdmin,
  TAvlblmin
FROM tblProductionEffcyDetails
WHERE (DAY(EnteredDate) >= DAY(GETDATE()) - 5)
ORDER BY EnteredDate DESC

Are you really using `Mysql`, query syntax belongs to `SQL SERVER` — Pரதீப், Oct 18 '16 at 07:20

score 1 · Answer 1 · answered Oct 18 '16 at 07:50

1

For SQL SERVER 2012+ use this

WHERE  EnteredDate >=  dateadd(dd,-4,eomonth(getdate(),-1)) 
  and  EnteredDate < dateadd(dd,1,eomonth(getdate()))

For older versions

WHERE  EnteredDate >=  dateadd(dd,-5,DATEADD(month, DATEDIFF(month, 0, getdate()), 0)) 
  and EnteredDate < DATEADD(d, -1, DATEADD(m, DATEDIFF(m, 0, getdate()) + 1, 0))

answered Oct 18 '16 at 07:50

Pரதீப்

91,748
19
131
172

Iam using SQL SERVER 2012 – Shankar Naren Oct 18 '16 at 08:00
@user3926897 - Ofcourse that is the requirement right.. Last 5 days from previous month and current month data – Pரதீப் Oct 18 '16 at 08:27

Jaydip Jadhav · Accepted Answer · 2016-10-18T08:17:28.837

1

Try this : to get data from last months last five days

WHERE EnteredDate > (DATEADD(DAY,-5,DATEADD(month, DATEDIFF(month, 0, GETDATE()), 0))

edited Oct 18 '16 at 08:17

answered Oct 18 '16 at 07:56

Jaydip Jadhav

12,179
6
24
40

Simple SQL Query: need this month data and previous month last 5 days data together

2 Answers2