I know how to get data from the last 30 days using something like the code below...
SELECT * FROM userdata
WHERE DATEDIFF(day, POST_DATE, GetDate()) <= 30
but how can I get the data for just the current month thus far. For example, if it's May 9, select all posts from May 1-9 and do the same no matter what day it is (May 1-15, or May 1-30).