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

User · Answer

cal days in month   should give you the total number of days in the month  and therefore  the last one

User · Answer

month   10     october   firstday   date  01-     month    -Y     lastday   date date  t   strtotime  firstday     -     month    -Y

User · Answer

First date of the current date echo date  Y-m-d   mktime 0  0  0  date  m    1  date  Y      echo   lt br   gt       Last date of the current date echo date  Y-m-d   mktime 0  0  0  date  m   1  0  date  Y

User · Answer

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

User · Answer

Basically    lastDate   date  Y-m-t   strtotime  query d      Date t parameter return days number in current month

User · Answer

Try this   if you are using PHP 5 3   in php   query date    2010-02-04    date   new DateTime  query date     First day of month  date- gt modify  first day of this month     firstday   date- gt format  Y-m-d      Last day of month  date- gt modify  last day of this month     lastday   date- gt format  Y-m-d      For finding next month last date  modify as follows     date- gt modify  last day of 1 month     echo  date- gt format  Y-m-d      and so on

User · Answer

Print only current month week   function my week range  date         ts   strtotime  date        start    date  w    ts     0     ts   strtotime  last sunday    ts       echo  currentWeek   ceil  date  d  strtotime  date   - date  w  strtotime  date   - 1    7    1       start date   date  Y-m-d    start   end date date  Y-m-d   strtotime  next saturday    start        if  currentWeek  1            start date   date  Y-m-01   strtotime  date         else if  currentWeek  5           end date   date  Y-m-t   strtotime  date         else               return array  start date   end date        date range list  start date   end date    my week range  new fdate

User · Answer

Get Current Month s First Date And Last Date  echo  Today Date      query date   date  d-m-Y    echo   lt br gt  First day of the month     date  01-m-Y   strtotime  query date    echo   lt br gt  Last day of the month     date  t-m-Y   strtotime  query date

User · Answer

You might want to look at the strtotime and date functions    lt  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

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

Examples related to php

Examples related to date