Selecting a "MONTH" from a date field...

I have 6 months worth of data in a MSSQL database.

I want to pull out only X month worth of data at a time.

So for example, I just want every entry in the DB, that was from the month of january 200x.

What would my select statement look like??

Currently it looks like this:

$record_set = mssql_query("SELECT * FROM $view_status_tbl ORDER BY date", $cnx);

Which of course grabs EVERYTHING. I need to filter it a bit more.

Any help would be appreciated.

Never mind! 🙂

Figured it out 🙂

Show me, show us, show other ppl! Please?

Well...I took:

$record_set = mssql_query("SELECT * FROM $view_status_tbl ORDER BY date", $cnx);

And made it:

$record_set = mssql_query("SELECT * FROM $view_status_tbl WHERE month(daet) = $month AND year(date) = $year ORDER BY date", $cnx);

$month and $year are passed to the script via a form.

Works good.