Current Month vs hard coding the month in SQL

[sap1958]

I have a portion of code:

select ID,Name
where gifteffdat >='2009-10-01' and gifteffdat <='2009-10-30'
from gifts

Now I need a way of showing records each month as long as thet fall within a calendar month. I need to get away from hardcoding the month range

I need something like if the gifteffdat falls within the first and last day of the currentmonth, show the records

 

[markros]

See

http://wiki.lessthandot.com/index.php/How_to_find_the_first_and_last_days_in_years,_months_etc

 

[simian336]

You might also want consider a calendar table.

http://sqlserver2000.databases.aspf...nsider-using-an-auxiliary-calendar-table.html

Simi

 

[PWise]

how about
select ID,Name
from gifts
where month(gifteffdat)=month(Getdate())
And Year(gifteffdat)=Year(Getdate())

 

[markros]

Check this thread

http://social.msdn.microsoft.com/Fo...l/thread/53869082-8376-4182-8cc0-143774c8cfc3

 

[JeffModen]

 SELECT ID,Name
   FROM gifts
  WHERE gifteffdat >= DATEADD(mm,DATEDIFF(mm,0,GETDATE()),0)
    AND gifteffdat <  DATEADD(mm,DATEDIFF(mm,0,GETDATE())+1,0)

--Jeff Moden
-------------------------------------------------------------------------------
"RBAR" is pronounced "ree-bar" and is a "Modenism" for "Row By Agonizing Row