DATEPART WITH YEAR AND MONTH

• jerome.morris

  SSCrazy

  Points: 2829

  More actions

  September 11, 2013 at 1:54 pm

  #297727

  Hi all how do I query datepart to include month also when passing a variable from my app. My attempt below

  WHERE (DATEPART(yyyy, @date1) = DATEPART(yyyy, Docket_Date) AND (DATEPART(m, @date1) = DATEPART(m, Docket_Date)))

• ScottPletcher

  SSC Guru

  Points: 100262

  More actions

  September 11, 2013 at 2:04 pm

  #1649489

  WHERE

  Docket_Date >= DATEADD(MONTH, DATEDIFF(MONTH, 0, @date1), 0) AND

  Docket_Date < DATEADD(MONTH, DATEDIFF(MONTH, 0, @date1) + 1, 0)

  SQL DBA,SQL Server MVP(07, 08, 09) "Money can't buy you happiness." Maybe so, but it can make your unhappiness a LOT more comfortable!