Tanveer’s Weblog

mktime() First Day of the Last Week

May 7, 2008 · Leave a Comment

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));

?>

Categories: Fun · cakePHP

0 responses so far ↓

  • There are no comments yet...Kick things off by filling out the form below.

Leave a Comment