So I have a table that has the month and year broken down, for example field called Month has the number 7 in it (this month) and the Year field has 2011. Theres also additional months years, etc. How can I query this to show just the current year, month?
In SQL Server you can use
DAY instead of
(at least in SQL Server 2005/2008, I'm not sure about SQL Server 2000 and older)
I prefer using these "short forms" because to me,
YEAR(getdate()) is shorter to type and better to read than
So you could also query your table like this:
select * from your_table where month_column = MONTH(getdate()) and year_column = YEAR(getdate())