matfish Posted June 14, 2007 Share Posted June 14, 2007 Hi, Im having to do a bit of string manipulation and with the given values I need help trying to find out the last day of the month... Im passing the date format of: yyyymm (200706 being this month)(and im unable to change this for several reasons) and Im using substr to find the first 4 chars as the year and the last 2 chars of the month. With these two values I need to find the last day of the month (in this case last day of this month would be 30) At the end I then do an sql query where timestamp>=yyyy-mm-01 AND timestamp<=yyyy-mm-dd (where dd is the last day of the month value im trying to find.) Any ideas with the above issue? Many thanks! Quote Link to comment https://forums.phpfreaks.com/topic/55561-weird-date-format-and-last-day-of-the-month/ Share on other sites More sharing options...
kenrbnsn Posted June 14, 2007 Share Posted June 14, 2007 Use the "t" format of the date() function: <?php $date = "200707"; $days_in_month = date('t',strtotime($date . '01')); echo $days_in_month; ?> Ken Quote Link to comment https://forums.phpfreaks.com/topic/55561-weird-date-format-and-last-day-of-the-month/#findComment-274501 Share on other sites More sharing options...
matfish Posted June 15, 2007 Author Share Posted June 15, 2007 Many thanks! Works a treat Quote Link to comment https://forums.phpfreaks.com/topic/55561-weird-date-format-and-last-day-of-the-month/#findComment-275223 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.