getdate

add a note User Contributed Notes

John Sherwood
15-May-2006 02:10


In response to the "Simple routine for determining whether a date in mySQL format has gone past":



function pastdate($t)

{

   if (strtotime($t) < time())

      return false;

   return true;

}



or you could use



mysql_select("SELECT UNIX_TIMESTAMP(fieldname) FROM tablename"), which would give you the date in seconds since unix epoch, and which you could compare to time().

king_of_t3rrors at hotmail dot com
29-Apr-2006 12:55


The function below is also wrong :)



This one is right ( I promise ):



{

  $today = getdate() ;

   

  $datebits=explode('-',$date);

  

  $year = intval($datebits[strpos($formato, 'y')]);

  $mon = intval($datebits[strpos($formato, 'm')]);

  $day = intval($datebits[strpos($formato, 'd')]);

  

  $y=0; $m=0; 

   if ( $today['year'] > $year ) {

       $y=1 ;

   }

   if ( $today['mon'] > $mon ) {

       $m=1;

   }

   if ( $y==1 || $m==1 ) {

       return true; //past date

   }

   if ( $today['year'] == $year ) {

       if ( $today['mon'] > $mon ) {

           return true; //past date

       }

          if ( $today['mon']==$mon ) {

              if ( $today['mday'] > $day ) {

                  return true; //past date

              }

          }

   }

   return false;

}

king_of_t3rrors at hotmail dot com
27-Apr-2006 08:12


This is a correction of the note posted on 27-Feb-2006 03:29:



"Simple routine for determining whether some date given

 in MySQL format (yyyy-mm-dd) has gone past."



I think that code was wrong.



My code is:



function is_past( $date,$format )

// When calling this function remember:

// $date format: yyyy-mm-dd

// $format--> insert 'ymd' as second argument

{

  $today = getdate() ;

   

  $datebits=explode('-',$date);

  

  $year = intval($datebits[strpos($format, 'y')]);

  $mon = intval($datebits[strpos($format, 'm')]);

  $today = intval($datebits[strpos($format, 'd')]);

  

   if ( $today['year'] > $year ) {

       return false ;

   }

   if ( $today['mon'] > $mon ) {

       return false;

   }

   if ( $today['mday'] > $today ) {

       return false;

   }

   return true;

          

}

Cas_AT_NUY_DOT_INFO
04-Mar-2006 09:47


// This functions calculates the next date only using business days

// 2 parameters, the startdate and the number of businessdays to add

    function calcduedate($datecalc,$duedays) {

    $i = 1;

    while ($i <= $duedays) {

        $datecalc += 86400; // Add a day.

        $date_info  = getdate( $datecalc );

        if (($date_info["wday"] == 0) or ($date_info["wday"] == 6) )  {

            $datecalc += 86400; // Add a day.

            continue;

        }

        $i++;

    }

    return $datecalc ;

    }

27-Feb-2006 10:29


Simple routine for determining whether some date given in MySQL format (yyyy-mm-dd) has gone past.  E.g., has a membership expired or a special offer gone stale. 



function is_past( $date )

{

    $today = getdate() ;

    $yyyy = intval(substr($date,0,4)) ;

    $mm = intval(ltrim(substr($date,5,2),'0')) ;

    $dd = intval(ltrim(substr($date,8,2),'0')) ;

    if ( $today['year'] > $yyyy ) return true ;

    if ( $today['year'] < $yyyy ) return false ;

    if ( $today['mon'] > $mm ) return true ;

    if ( $today['mon'] < $mm ) return false ;

    if ( $today['mday'] > $dd ) return true ;

    return false ;

}

WAYLER - suwala at timpadd dot pl
09-Feb-2006 08:13


I think this is better method to calculate day difference between two timestamps:

<? php

   if( $first_timestamp > $second_timestamp )

   {

       die('Reverse timestamps');

   }

   else

   {

       $first_date  = getdate( $first_timestamp );   

       $second_date = getdate($second_timestamp);

        $years_between = $second_date['year'] - $first_date['year'];

       if($years_between==0)

        {

            $days_between = $second_date['yday'] - $first_date['yday'];

        }

       if($years_between>0)

        {

            $start_year = 365;

            $count_365_years = 0;

            $count_366_years = 0;

            if($first_date['year']%4==0) $start_year = 366;

            for($i = 1; $i<=$years_between-1; $i++)

            {

                 if(($first_date['year']+$i)%4==0) $count_366_years++;

                 else{ $count_365_years++; }

            }

            $days_between = $start_year - $first_date['yday'] + 365*$count_365_years + 366*$count_366_years + $second_date['yday'];

        }

   }



?>



Should works every time :)

mbaart at planet dot nl
28-Jan-2006 09:34


A simple way to calculate the days between to timestamps:



<?php

    if( $first_timestamp > $second_timestamp )

    {

        die('Reverse timestamps');

    } else 

    {

        $first_date  = getdate( $first_timestamp  );

        $second_date = getdate( $second_timestamp );

        $days_in_between = ($second_date['year']-$first_date['year'])*365 +

                           ($second_date['yday']-$first_date['yday']);

    }

?>



At least, given that every year has 365 days :)

datacompboy at river-net dot org
18-Dec-2005 12:06


Note: this function returns a gmt time, not your local.

datacompboy at river-net dot org
18-Dec-2005 12:01


Note: this function returns a gmt time, not your local.

OREN WISMAN
10-Oct-2005 04:43


add few days for today date and convert to mysql date format 



<?php

    $days_2_add = 2;

    $expired  = mktime(0, 0, 0, date("m"), date("d")+$days_2_add, date("Y"));

    $expired  = date("Y-m-d",$expired);



?>

timtaler [at] mailueberfall [dot] de
12-Sep-2005 11:35


# very nice function to check for a leap year

$arr_date = getdate();

$jahr = $arr_date['year'];

if ( $jahr % 4 == 0 ){

    if ( $jahr % 100 == 0 ){

        if ( $jahr % 400 == 0 ){

            $ydays = 366; 

        }

        else{

            $ydays = 365;

        }

     }

     else{

       $ydays = 366;

     }

}

else{

    $ydays = 365;

}

$one_year = ($ydays * 24 * 60 * 60);  # create a int varibale for one year

leo25in at yahoo dot com
11-May-2005 08:17


getting weekday(actual date) from any give date.



function cal_date($wday,$tstamp)

{

    return $tstamp-($wday*(24*3600));

}



function getweekday($m,$d,$y)

{

    $tstamp=mktime(0,0,0,$m,$d,$y);

    

    $Tdate = getdate($tstamp);

    

    $wday=$Tdate["wday"];

    

    switch($wday)

    {

        case 0;

        $wstamp=cal_date($wday,$tstamp);

        //echo date("Y-m-d",$wstamp);

        break;

        

        case 1;

        $wstamp=cal_date($wday,$tstamp);

        //echo date("Y-m-d",$wstamp);

        break;

        

        

        case 2;

        $wstamp=cal_date($wday,$tstamp);

        //echo date("Y-m-d",$wstamp);

        break;

        

        case 3;

        $wstamp=cal_date($wday,$tstamp);

        //echo date("Y-m-d",$wstamp);

        break;

        

        case 4;

        $wstamp=cal_date($wday,$tstamp);

        //echo date("Y-m-d",$wstamp);

        break;

        

        case 5;

        $wstamp=cal_date($wday,$tstamp);

        //echo date("Y-m-d",$wstamp);

        break;

        

        case 6;

        $wstamp=cal_date($wday,$tstamp);

        //echo date("Y-m-d",$wstamp);

        break;

    }

    

    

     $w["day"]=date("d",$wstamp);

     $w["month"]=date("m",$wstamp);

     $w["year"]=date("Y",$wstamp);

     

     return $w;



}

ahigerd at stratitec dot com
06-Apr-2005 05:05


The comment below about getdate() being insensitive to LOCALE is simply incorrect:



<?php print_r(getdate(0)); ?>



Array

(

    [seconds] => 0

    [minutes] => 0

    [hours] => 18

    [mday] => 31

    [wday] => 3

    [mon] => 12

    [year] => 1969

    [yday] => 364

    [weekday] => Wednesday

    [month] => December

    [0] => 0

)



Note that I'm in CDT at the moment.

davidhc at gmail dot com
21-Jan-2005 04:55


function getDateForMysqlDateField() {

    $date = getDate();

    foreach($date as $item=>$value) {

        if ($value < 10)

            $date[$item] = "0".$value;

    }

    return $date['year']."-".$date['mon']."-".$date['mday']." ".$date['hours'].":".$date['minutes'].":".$date['seconds'];

}

pascal dot bonderff at wanadoo dot fr
06-Nov-2004 04:32


Note that this fonction doesn't care about LOCALE settings. use strftime insteand

Liis make
16-Sep-2004 06:22


function win2unix($date_string,$date_timestamp)

{



   $epoch_diff = 11644473600; // difference 1601<>1970 in seconds. see reference URL

   $date_timestamp = $date_timestamp * 0.0000001;

   $unix_timestamp = $date_timestamp - $epoch_diff;

   echo date($date_string,$unix_timestamp);    

}

getisomonday($year, $week)
22-Apr-2004 05:58


getdate does not convert week numbers. this function relies on strftime to find a timestamp that falls on the monday of specified year and ISO week:



<?php function getisomonday($year, $week) {

        # check input

        $year = min ($year, 2038); $year = max ($year, 1970);

        $week = min ($week, 53); $week = max ($week, 1);

        # make a guess

        $monday = mktime (1,1,1,1,7*$week,$year);

        # count down to week

        while (strftime('%V', $monday) != $week)

                $monday -= 60*60*24*7;

        # count down to monday

        while (strftime('%u', $monday) != 1)

                $monday -= 60*60*24;

        # got it

        return $monday;

} ?>

Yura Pylypenko (plyrvt at mail dot ru)
15-Sep-2003 09:29


In addition to canby23 at ms19 post:

It's a very bad idea to consider day having 24 hours (86400 secs), because some days have 23, some - 25 hours due to daylight saving changes. Using of mkdate() and strtotime() is always preferred. strtotime() also has a very nice behaviour of datetime manipulations:

<?php

echo strtotime ("+1 day"), "\n";

echo strtotime ("+1 week"), "\n";

echo strtotime ("+1 week 2 days 4 hours 2 seconds"), "\n";

echo strtotime ("next Thursday"), "\n";

echo strtotime ("last Monday"), "\n"; 

?>

intronis
12-Sep-2003 02:04


When adding a timestamp to a database from php, be carefule because if your DB Server is a different computer than your webserver, the NOW() function in the SQL will use the DB Server's time, and not the web server's. You can use NTP to synch the times on both computers.

coolen at astron dot nl
09-Dec-2002 10:36


Yup, it does  so the getdate gives you the wrong daynumber.


using the following modification will give you the exact weeknr:





function week_of_year($nDay,$nMonth,$nYear)


{


   $date=getDate(mktime(9,0,0,$nMonth,$nDay,$nYear));


   $weeknr=floor(($date["yday"]+1)/7)+1;


   $weeknr %=52;


   return $weeknr;


}

squagmire at yaspoo dot com
18-Mar-2002 03:39


How I created a local UNIX timestamp running PHP on Windows 2000.  Similar to other functions already posted here, but I figured I'd stick my two cents in.



function get_time_at_page_load() {

    global $time_at_page_load;

    $temp = getdate(); 

    $time_at_page_load = $temp['year'];

    $zerofill = array

    (    'mon'        =>    '-'

    ,    'mday'        =>    '-'

    ,    'hours'        =>    ' '

    ,    'minutes'    =>    ':'

    ,    'seconds'    =>    ':'

    );

    while( list( $name, $pfix ) = each( $zerofill ) ) {

        if ($temp[$name] < 10) $temp[$name] = (string)'0'.$temp[$name];

        $time_at_page_load .= $pfix.$temp[$name];

    }

    $time_at_page_load = strtotime($time_at_page_load);

}

logan dot hall at asu dot edu
12-Mar-2002 04:32


It seems that 'yday' (the day of the year) that php produces is one less than what the unix 'date +%j' produces.



Not sure why this is, but I would guess that php uses 0-365 rather than 1-366 like unix does.  Just something to be careful of.

22-Oct-2001 07:55


Another way to map US day no to European count





function sunsat_to_monsun($wday)


{


   return ($wday + 6) % 7;


}





And a bit faster code, to calculate it directly from timestamp:





$wday = (time() % 604800 / 86400 + 3) % 7;

hfuecks at hotmail dot com
20-Aug-2001 10:36


If you wanted to find which day of the week corresponds to a particular date you could do something like this (for August 20th, 2001 - a Monday!) ;





<?





$timestamp = mktime(0,0,0,8,20,2001);


$date = getdate ($timestamp);


$dayofweek = $date['wday'];





echo ( "$dayofweek" );





?>





This returns a 1 (0 being Sunday)

ih2 at morton-fraser dot com
17-Oct-2000 08:01


To do comparisons on dates stored in mysql db against 7 days ago, 1 month ago etc use the following: 


$last_week = date("Y-m-d", mktime(0,0,0, date(m), date(d)-7,date(Y)));





if($date > $last_week)


    {


     etc.


This allows for intelligent looping i.e. works at start/end of month/year


I have noticed other postings re this and they have not worked for me.Hope this helps.

zparker at rpinteractive dot com
07-Mar-2000 07:14


Re: timestamping w/ php + mysql.





If you're writing a php script and just want a quick timestamp for mysql, there's an easier method.


Create a field of type datetime, and then do the following:





insert into blah (blah, tstamp) values ('blah', NOW());


of course, if you're doing something more complex than timestamping, then you'll need to use the php method. but for timestamping, this is less hassle. ;)

ems at itg dot net
15-Feb-2000 02:28


*Note* - Month and day are NOT zero-filled, so be careful when inserting dates generated by getdate(time()) into a database.

add a note

getdate

说明