2016-06-26 12:21
浏览 285


How can i get a Date of Monday and Date of Sunday if i have specific Date in mysql DATETIME format ?

i am trying to get the week's first day's date and last day's date in which the given date falls.

i have date '2016-06-05' its in 'Y-m-d' and i am trying it like this way.

$date = '2016-06-05'; 
echo date("Y-m-d", strtotime('monday this week', strtotime($date))), "
echo date("Y-m-d", strtotime('sunday this week', strtotime($date))), "

but its giving


which is wrong week, it should give


i even tried like this way.

$date = '2016-06-05';
echo date("Y-m-d", strtotime('monday', strtotime('this week', strtotime($date)))), "
echo date("Y-m-d", strtotime('sunday', strtotime('this week', strtotime($date)))), "


$date = '2016-06-05'; 
echo date("Y-m-d", strtotime('monday', strtotime($date))), "
echo date("Y-m-d", strtotime('sunday', strtotime($date))), "

using PHP 5.3

what am i missing here ?


i came up with this, this is giving expected output.

function get_monday_sunday($date){
$dates_array = array();

    if(date('N', strtotime($date)) == 7){

    $dates_array['monday'] = date("Y-m-d", strtotime('Monday last week', strtotime($date)));   
    $dates_array['sunday'] =  date("Y-m-d", strtotime('Sunday last week', strtotime($date)));   


    $dates_array['monday'] = date("Y-m-d", strtotime('Monday this week', strtotime($date)));   
    $dates_array['sunday'] =  date("Y-m-d", strtotime('Sunday this week', strtotime($date)));   
return $dates_array;

$date = '2016-06-05'

looks like when the day is last day of week, then next week starts over, i.e. php week start is sunday i guess.

  • 写回答
  • 好问题 提建议
  • 追加酬金
  • 关注问题
  • 邀请回答

1条回答 默认 最新

相关推荐 更多相似问题