how to get the first and last days of a given month

Question

I wish to rewrite a mysql query which use month() and year() functions to display all the posts from a certain month which goes to my function as a 'Y-m-d' parameter format, but I don't know how can I get the last day of the given month date.

$query_date = '2010-02-04'; list($y, $m, $d) = explode('-', $query_date); $first_day = $y . '-' . $m . '-01'; 

Answer 1

You might want to look at the strtotime and date functions.

<?php  $query_date = '2010-02-04';  // First day of the month. echo date('Y-m-01', strtotime($query_date));  // Last day of the month. echo date('Y-m-t', strtotime($query_date)); 

Answer 2

I know this question has a good answer with 't', but thought I would add another solution.

$first = date("Y-m-d", strtotime("first day of this month")); $last = date("Y-m-d", strtotime("last day of this month"));