Selecting month of Date

jdh

What I am trying to do is only select only a certain month from the database. I am storing the values as the MySQL date function, YYYY-MM-DD.

I could have php have the starting date, and ending date of the current month. Then have MySQL select the ones between those, but I think there is a better way, and I wouldn't find a function in MySQL that would do it..... anyone have an idea?

Thanks in advance,

acidbox

$date = YYYY-MM-DD

$month = substr($date, 5, 2);

jdh

I was looking for more of a MySQL query statement.... this is what I am trying, and it doesn't work:

SELECT date_recd FROM checks WHERE date_recd = '$thisyear-$thismonth-%%';

jdh

LOL

Here is my solution, for those who would like to do the same....

 
$thisyear = date("Y");
$thismonth = date("m");
$sql = "SELECT * FROM dates WHERE MONTH('date_in') = '$thismonth' AND YEAR('date_in') = '$thisyear'";

Sometimes it just helps to talk it out. 🙂

acidbox

you really ought to store your dates in UNIX timestamp format and then break appart the dates. It makes it much easier to sort and break appart the string.