The mktime() function returns the Unix timestamp for a date.
This timestamp contains the number of seconds between the Unix Epoch (January 1 1970 00:00:00 GMT) and the time specified.
Assumed Moday is the firstday of the week.
<?php //YESTERDAY $yesterday = date("Y-m-d H:i:s",mktime(0, 0, 0, date("m") , date("d")-1, date("Y"))); //THIS WEEK $fromDate = date("Y-m-d H:i:s",mktime(0, 0, 0, date("n"), date("j"), date("Y")) - ((date("N")-1)*3600*24)); $toDate = CURRENT_TIMESTAMP; //LAST WEEK $fromDate = date("Y-m-d H:i:s",mktime(0, 0, 0, date("n"), date("j")-6, date("Y")) - ((date("N"))*3600*24)); $toDate = date("Y-m-d H:i:s",mktime(23, 59, 59, date("n"), date("j"), date("Y")) - ((date("N"))*3600*24)); //THIS MONTH $fromDate = date("Y-m-d H:i:s",mktime(0, 0, 0, date("m") , 1, date("Y"))); $toDate = CURRENT_TIMESTAMP; //LAST MONTH $fromDate = date("Y-m-d H:i:s",mktime(0, 0, 0, date("m")-1 , 1 , date("Y"))); $toDate = date("Y-m-d H:i:s",mktime(23, 59, 59, date("m"), date("d")-date("j"), date("Y"))); //THIS YEAR $fromDate = date("Y-m-d H:i:s",mktime(0, 0, 0, date(1) , date(1), date("Y"))); $toDate = CURRENT_TIMESTAMP; //LAST YEAR $fromDate = date("Y-m-d H:i:s",mktime(0, 0, 0, 1 , 1, date("Y")-1)); $toDate = date("Y-m-d H:i:s",mktime(23, 59, 59, 12, 31, date("Y")-1)); ?>




0 responses so far ↓
There are no comments yet...Kick things off by filling out the form below.