MySQL last day of month

[MoFish]

Hi,

Is it possible to get the last date of a month in mysql on a start date variable?

 

Example...

WHERE date >= '$date' and date <= GETLASTDAY('$date'):

I'm aware this wont work - but may help understand what i'm trying to achieve.

I currently pass in a variable called $date which has a value of "2013-11-01" . I'm hoping to execute a mysql query where it would figure out the last possible date in that month based on the $date variable e.g '2013-11-30'.

 

In theory i want to execute something like the below - but it automagically figure out the second value

WHERE date >= '2013-11-01' and date <= '2013-11-30':

Is there an easy way to do this?

 

Thanks,

 

MoFish

[Barand]

$date = '2013-11-01';
$last = date('Y-m-t', strtotime($date));
echo "$date - $last"; // --> 2013-11-01 - 2013-11-30

or you could do

 

WHERE EXTRACT(YEAR_MONTH FROM date) = EXTRACT(YEAR_MONTH FROM '$date')

Edited November 28, 2013 by Barand

[MoFish]

Thats exactly what I was looking for.

 

Thank you Barand!