3v4l.org

run code in 300+ PHP versions simultaneously
<?php $correctTimestamp = correctMondayTimestamp(); $time_query = "data_ordine BETWEEN DATE('".date("Y-m-d",$correctTimestamp)."') AND DATE_ADD(DATE('".date("Y-m-d",strtotime("sunday this week"))."'), INTERVAL 1 DAY)"; $begin = new DateTime(date("c", $correctTimestamp)); echo "TQ: $time_query\nB: ".date_format('U',$begin); function correctMondayTimestamp(){ if(date('N') == 7) { return strtotime('monday last week'); } else { return strtotime('monday this week'); } }

preferences:
49.03 ms | 402 KiB | 5 Q