Last updated: Fri, 09 May 2008

date

(PHP 4, PHP 5)

date — Format a local time/date

Description

string date ( string $format [, int $timestamp ] )

Returns a string formatted according to the given format string using the given integer timestamp or the current time if no timestamp is given. In other words, timestamp is optional and defaults to the value of time().

Parameters

format

The format of the outputted date string. See the formatting options below.

**The following characters are recognized in the *`format`* parameter string**
`format` character	Description	Example returned values
Day	---	---
d	Day of the month, 2 digits with leading zeros	01 to 31
D	A textual representation of a day, three letters	Mon through Sun
j	Day of the month without leading zeros	1 to 31
l (lowercase 'L')	A full textual representation of the day of the week	Sunday through Saturday
N	ISO-8601 numeric representation of the day of the week (added in PHP 5.1.0)	1 (for Monday) through 7 (for Sunday)
S	English ordinal suffix for the day of the month, 2 characters	st, nd, rd or th. Works well with j
w	Numeric representation of the day of the week	0 (for Sunday) through 6 (for Saturday)
z	The day of the year (starting from 0)	0 through 365
Week	---	---
W	ISO-8601 week number of year, weeks starting on Monday (added in PHP 4.1.0)	Example: 42 (the 42nd week in the year)
Month	---	---
F	A full textual representation of a month, such as January or March	January through December
m	Numeric representation of a month, with leading zeros	01 through 12
M	A short textual representation of a month, three letters	Jan through Dec
n	Numeric representation of a month, without leading zeros	1 through 12
t	Number of days in the given month	28 through 31
Year	---	---
L	Whether it's a leap year	1 if it is a leap year, 0 otherwise.
o	ISO-8601 year number. This has the same value as Y, except that if the ISO week number (W) belongs to the previous or next year, that year is used instead. (added in PHP 5.1.0)	Examples: 1999 or 2003
Y	A full numeric representation of a year, 4 digits	Examples: 1999 or 2003
y	A two digit representation of a year	Examples: 99 or 03
Time	---	---
a	Lowercase Ante meridiem and Post meridiem	am or pm
A	Uppercase Ante meridiem and Post meridiem	AM or PM
B	Swatch Internet time	000 through 999
g	12-hour format of an hour without leading zeros	1 through 12
G	24-hour format of an hour without leading zeros	0 through 23
h	12-hour format of an hour with leading zeros	01 through 12
H	24-hour format of an hour with leading zeros	00 through 23
i	Minutes with leading zeros	00 to 59
s	Seconds, with leading zeros	00 through 59
u	Milliseconds (added in PHP 5.2.2)	Example: 54321
Timezone	---	---
e	Timezone identifier (added in PHP 5.1.0)	Examples: UTC, GMT, Atlantic/Azores
I (capital i)	Whether or not the date is in daylight saving time	1 if Daylight Saving Time, 0 otherwise.
O	Difference to Greenwich time (GMT) in hours	Example: +0200
P	Difference to Greenwich time (GMT) with colon between hours and minutes (added in PHP 5.1.3)	Example: +02:00
T	Timezone abbreviation	Examples: EST, MDT ...
Z	Timezone offset in seconds. The offset for timezones west of UTC is always negative, and for those east of UTC is always positive.	-43200 through 50400
Full Date/Time	---	---
c	ISO 8601 date (added in PHP 5)	2004-02-12T15:19:21+00:00
r	» RFC 2822 formatted date	Example: Thu, 21 Dec 2000 16:01:07 +0200
U	Seconds since the Unix Epoch (January 1 1970 00:00:00 GMT)	See also time()

Unrecognized characters in the format string will be printed as-is. The Z format will always return 0 when using gmdate().

Note: Since this function only accepts integer timestamps the u format character is only useful when using the date_format() function with user based timestamps created with date_create().

timestamp

The optional timestamp parameter is an integer Unix timestamp that defaults to the current local time if a timestamp is not given. In other words, it defaults to the value of time().

Return Values

Returns a formatted date string. If a non-numeric value is used for timestamp , FALSE is returned and an E_WARNING level error is emitted.

Errors/Exceptions

Every call to a date/time function will generate a E_NOTICE if the time zone is not valid, and/or a E_STRICT message if using the system settings or the TZ environment variable. See also date_default_timezone_set()

ChangeLog

Version	Description
5.1.0	The valid range of a timestamp is typically from Fri, 13 Dec 1901 20:45:54 GMT to Tue, 19 Jan 2038 03:14:07 GMT. (These are the dates that correspond to the minimum and maximum values for a 32-bit signed integer). However, before PHP 5.1.0 this range was limited from 01-01-1970 to 19-01-2038 on some systems (e.g. Windows).
5.1.0	Now issues the `E_STRICT` and `E_NOTICE` time zone errors.
5.1.1	There are useful constants of standard date/time formats that can be used to specify the `format` parameter.

Examples

Example #1 date() examples


<?php
// set the default timezone to use. Available since PHP 5.1
date_default_timezone_set('UTC');


// Prints something like: Monday
echo date("l");

// Prints something like: Monday 8th of August 2005 03:12:46 PM
echo date('l jS \of F Y h:i:s A');

// Prints: July 1, 2000 is on a Saturday
echo "July 1, 2000 is on a " . date("l", mktime(0, 0, 0, 7, 1, 2000));

/* use the constants in the format parameter */
// prints something like: Mon, 15 Aug 2005 15:12:46 UTC
echo date(DATE_RFC822);

// prints something like: 2000-07-01T00:00:00+00:00
echo date(DATE_ATOM, mktime(0, 0, 0, 7, 1, 2000));
?>

You can prevent a recognized character in the format string from being expanded by escaping it with a preceding backslash. If the character with a backslash is already a special sequence, you may need to also escape the backslash.

Example #2 Escaping characters in date()


<?php
// prints something like: Wednesday the 15th
echo date("l \\t\h\e jS");
?>

It is possible to use date() and mktime() together to find dates in the future or the past.

Example #3 date() and mktime() example


<?php
$tomorrow  = mktime(0, 0, 0, date("m")  , date("d")+1, date("Y"));
$lastmonth = mktime(0, 0, 0, date("m")-1, date("d"),   date("Y"));
$nextyear  = mktime(0, 0, 0, date("m"),   date("d"),   date("Y")+1);
?>

Note: This can be more reliable than simply adding or subtracting the number of seconds in a day or month to a timestamp because of daylight saving time.

Some examples of date() formatting. Note that you should escape any other characters, as any which currently have a special meaning will produce undesirable results, and other characters may be assigned meaning in future PHP versions. When escaping, be sure to use single quotes to prevent characters like \n from becoming newlines.

Example #4 date() Formatting


<?php
// Assuming today is: March 10th, 2001, 5:16:18 pm

$today = date("F j, Y, g:i a");                 // March 10, 2001, 5:16 pm
$today = date("m.d.y");                         // 03.10.01
$today = date("j, n, Y");                       // 10, 3, 2001
$today = date("Ymd");                           // 20010310
$today = date('h-i-s, j-m-y, it is w Day z ');  // 05-16-17, 10-03-01, 1631 1618 6 Fripm01
$today = date('\i\t \i\s \t\h\e jS \d\a\y.');   // It is the 10th day.
$today = date("D M j G:i:s T Y");               // Sat Mar 10 15:16:08 MST 2001
$today = date('H:m:s \m \i\s\ \m\o\n\t\h');     // 17:03:17 m is month
$today = date("H:i:s");                         // 17:16:17
?>

To format dates in other languages, you should use the setlocale() and strftime() functions instead of date().

Notes

Note: To generate a timestamp from a string representation of the date, you may be able to use strtotime(). Additionally, some databases have functions to convert their date formats into timestamps (such as MySQL's » UNIX_TIMESTAMP function).

Tip

Timestamp of the start of the request is available in $_SERVER['REQUEST_TIME'] since PHP 5.1.


in regards to: [takzik at ebanat dot com]



simplest way of displaying / formatting dates. strtotime()



<?php

# Date: y-m-d => d-m-y

$time =explode("-","2008-01-01");

krsort($time);

print implode("-",$time);

?>

<p>Will return: 01-01-2008.

<?php

# Date: d-m-y => y-m-d

$time =explode("-","01-01-2008");

krsort($time);

print "<p>".implode("-",$time);

?>

<p>Will return: 2008-01-01.

<?php

# Quickest: Y-m-d => American Format

print date("m-d-Y",strtotime("2008-02-01"));

?>

<p>Will return: 02-01-2008.

<?php

# Quickest: Y-m-d => Brittish Format

print date("d.m.Y",strtotime("2008-01-01"));

?>

<p>Will return: 01.01.2008.

Anonymous
18-Mar-2008 02:56


Useful tool for creating DATE() specs without having to run 35 tests to get it right: http://www.bitbybit.dk/mysql/date_format/ (says mysql, but covers PHP as well)

Dave Schlaegel
18-Mar-2008 01:09


Here is an easy MySQL way of getting the difference in dates. For me it is more logical to do this on the select than running it though an additional PHP function after selecting the date. But depends on what your doing of course. I hope it helps.



SELECT ABS(DATEDIFF(NOW(),yourdateField)) as dateDiff

Anonymous
01-Mar-2008 06:05


## This will produce the first day of last month and the last day of last month

## 2008-01-01 2008-01-31

<?php

echo date("Y-m-01", strtotime("-1 month", strtotime(date("Y-m-d"))))." ".date("Y-m-d", strtotime("-1 day", strtotime(date("Y-m-01")))) ?>

jwagner dot DO at NOT dot SPAM dot digilog dot de
22-Feb-2008 07:06


The PHP4 replacement for ISO8601 posted by fokeyjoe has a little flaw:

The time in ISO is in 24 hour format, so an uppercase H must be used. 

Correct format is:



$sISO8601=date('Y-m-d\TH:i:s',$nTimestamp). substr_replace(date('O',$nTimestamp),':',3,0);



Short version for NOW:

$sISO8601=date('Y-m-d\TH:i:s'). substr_replace(date('O'),':',3,0);

Juan Paredes
26-Jan-2008 04:59


Complementing the information by ZZigc on 28-Dec-2007 07:38, if you want to calculate the number of weeks in a given year, according to the week definition by ISO 8601, the following should be enough:



date('W', mktime(0,0,0,12,28,$year) );



(the last week on a give year always contains 28-Dec)

jc
31-Dec-2007 11:28


date("W") returns the iso8601 week number, while date("Y") returns the _current_ year. This can lead to odd results. For example today (dec 31, 2007) it returns 1 for the week and of course 2007 for the year. This is not wrong in a strict sense because iso defines this week as the first of 2008 while we still have 2007.





So, if you don't have another way to safely retrieve the year according to the iso8061 week-date - strftime("%G") doesn't work on some systems -, you should be careful when working with date("W"). 





For most cases strftime("%W") should be a safe replacement.





[edit: Much easier is to use "o" (lower case O) instead of "Y"]

ZZigc
29-Dec-2007 03:38


I wanted to get the number of weeks for particular year.



Example with date():

<?php



 $weeks_in_year = date("W", strtotime("12/31/2007"));



?>



It works for years smaller than current year, but returns '01' when year was the same or bigger as current year. 

Not sure if I missed something or maybe misused this function but I couldn't get it to work even with different date representations.



So the workaround was using different function.



Example with strftime():

<?php



 $weeks_in_year = strftime("%W",strtotime("12/31/2007"));



?>



Now it works as a charm.



PHP v.4.4.7

june at overlie dot no
19-Dec-2007 11:54


re: marius at svr dot ro



to anyone using marius' function, it needs some minor fixes (look for a ---->)



<?php

//The function returns the no. of business days between two dates and it skeeps the holidays

function getWorkingDays($startDate,$endDate,$holidays){

    //The total number of days between the two dates. We compute the no. of seconds and divide it to 60*60*24

    //We add one to inlude both dates in the interval.

    $days = (strtotime($endDate) - strtotime($startDate)) / 86400 + 1;



    $no_full_weeks = floor($days / 7);

    $no_remaining_days = fmod($days, 7);



    //It will return 1 if it's Monday,.. ,7 for Sunday

    $the_first_day_of_week = date("N",strtotime($startDate));

    $the_last_day_of_week = date("N",strtotime($endDate));



    //---->The two can be equal in leap years when february has 29 days, the equal sign is added here

    //In the first case the whole interval is within a week, in the second case the interval falls in two weeks.

    if ($the_first_day_of_week <= $the_last_day_of_week){

        if ($the_first_day_of_week <= 6 && 6 <= $the_last_day_of_week) $no_remaining_days--;

        if ($the_first_day_of_week <= 7 && 7 <= $the_last_day_of_week) $no_remaining_days--;

    }

    else{

        if ($the_first_day_of_week <= 6) $no_remaining_days--;

        //In the case when the interval falls in two weeks, there will be a Sunday for sure

        $no_remaining_days--;

    }



    //The no. of business days is: (number of weeks between the two dates) * (5 working days) + the remainder

//---->february in none leap years gave a remainder of 0 but still calculated weekends between first and last day, this is one way to fix it

   $workingDays = $no_full_weeks * 5;

    if ($no_remaining_days > 0 )

    {

      $workingDays += $no_remaining_days;

    }



    //We subtract the holidays

    foreach($holidays as $holiday){

        $time_stamp=strtotime($holiday);

        //If the holiday doesn't fall in weekend

        if (strtotime($startDate) <= $time_stamp && $time_stamp <= strtotime($endDate) && date("N",$time_stamp) != 6 && date("N",$time_stamp) != 7)

            $workingDays--;

    }



    return $workingDays;

}



//Example:



$holidays=array("2006-12-25","2006-12-26","2007-01-01");



echo getWorkingDays("2006-12-22","2007-01-06",$holidays)

// => will return 8

?>



Otherwise, I found this very useful, thanks marius:)

Bill at wLathrop com
14-Dec-2007 09:56


For JasonLFunk



I did some testing on the occurrence for a given date within the month (i.e 1st Monday, 2nd Wednesday, 3rd Friday, etc.). 



where $dDate is a getdate() array



intval(($dDate['mday']-1)/7)+1  



Returns an integer representing the week for a given date.  I tested on a complete calendar month and it seems to work well. 



I then convert to a string and compare to a string list of values to see if it is in the list.  If it is - it qualifies.  So, my list of values might be '2,4' representing every 2nd and 4th occurrence.

bikinyboy at example dot com
12-Dec-2007 12:44


This function is like date, but it "speaks" Hungarian (or an other language)



<?php

/*

  these are the hungarian additional format characters

  ö: full textual representation of the day of the week

  Ö: full textual representation of the day of the week (first character is uppercase),

  ő: short textual representation of the day of the week,

  Ő: short textual representation of the day of the week (first character is uppercase),

  ü: full textual representation of a month

  Ü: full textual representation of a month (first character is uppercase),

  ű: short textual representation of a month

  Ű: short textual representation of a month (first character is uppercase),

*/

function date_hu($formatum, $timestamp=0) {

  if (($timestamp <= -1) || !is_numeric($timestamp)) return '';

  $q['ö'] = array(-1 => 'w', 'vasárnap', 'hétfő', 'kedd', 'szerda', 'csütörtök', 'péntek', 'szombat');

  $q['Ö'] = array(-1 => 'w', 'Vasárnap', 'Hétfő', 'Kedd', 'Szerda', 'Csütörtök', 'Péntek', 'Szombat');

  $q['ő'] = array(-1 => 'w', 'va', 'hé', 'ke', 'sze', 'csü', 'pé', 'szo');

  $q['Ő'] = array(-1 => 'w', 'Va', 'Hé', 'Ke', 'Sze', 'Csü', 'Pé', 'Szo');

  $q['ü'] = array(-1 => 'n', '', 'január', 'február', 'március', 'április', 'május', 'június', 'július', 'augusztus', 'szeptember', 'október', 'november', 'december');

  $q['Ü'] = array(-1 => 'n', '', 'Január', 'Február', 'Március', 'Április', 'Május', 'Június', 'Július', 'Augusztus', 'Szeptember', 'Október', 'November', 'December');

  $q['ű'] = array(-1 => 'n', '', 'jan', 'febr', 'márc', 'ápr', 'máj', 'júni', 'júli', 'aug', 'szept', 'okt', 'nov', 'dec');

  $q['Ű'] = array(-1 => 'n', '', 'Jan', 'Febr', 'Márc', 'Ápr', 'Máj', 'Júni', 'Júli', 'Aug', 'Szept', 'Okt', 'Nov', 'Dec');



  if ($timestamp == 0)

    $timestamp = time();

  $temp = '';

  $i = 0;

  while ( (strpos($formatum, 'ö', $i) !== FALSE) || (strpos($formatum, 'Ö', $i) !== FALSE) || 

          (strpos($formatum, 'ő', $i) !== FALSE) || (strpos($formatum, 'Ő', $i) !== FALSE) || 

          (strpos($formatum, 'ü', $i) !== FALSE) || (strpos($formatum, 'Ü', $i) !== FALSE) || 

          (strpos($formatum, 'ű', $i) !== FALSE) || (strpos($formatum, 'Ű', $i) !== FALSE)) {

    $ch['ö']=strpos($formatum, 'ö', $i);

    $ch['Ö']=strpos($formatum, 'Ö', $i);

    $ch['ő']=strpos($formatum, 'ő', $i);

    $ch['Ő']=strpos($formatum, 'Ő', $i);

    $ch['ü']=strpos($formatum, 'ü', $i);

    $ch['Ü']=strpos($formatum, 'Ü', $i);

    $ch['ű']=strpos($formatum, 'ű', $i);

    $ch['Ű']=strpos($formatum, 'Ű', $i);

    foreach ($ch as $k=>$v)

      if ($v === FALSE)

        unset($ch[$k]);

    $a = min($ch);

    $temp .= date(substr($formatum, $i, $a-$i), $timestamp) . $q[$formatum[$a]][date($q[$formatum[$a]][-1], $timestamp)];

    $i = $a+1;

  }

  $temp .= date(substr($formatum, $i), $timestamp);

  return $temp;

}



echo date_hu('Y. ü j. (ö) G:i');

?>

redcore at gmail dot com
20-Nov-2007 10:24


For those of us who don't have 5.x installed (that puts a colon in the time zone)...



<?php

$timezone = date("O"); // get timezone

$timezone_end = substr($timezone, -2, 2); // get last two numbers

$timezone= substr($timezone, 0, -2); // get first half

echo $timezone = $timezone . ":" . $timezone_end; // add colon

?>

info at NOSPAM dot ogmatter dot com
30-Oct-2007 11:30


Hello, these notes have been very helpful and help me solve the following problem.



I have a db with scheduled items that contain a start date, a day to occur on and how many weeks from the next closest day to happen again.  I wrote the following script to do the following

1. Accept : starting date, the current date, the number of weeks between occurances and the day of the week it is to occur on.

2. Find the closest future day of the week argument from the start date.

3. Find out when the next time the item should happen via the weeks inbetween and the closest day of the week to the start date.



The result could be compared with your current date to trigger your periodical item or simply to find out when the next occurances will happen.



// $startDate:Date

// $todayDate:Date

// $weeks:Int - number of weeks in between

// $wantDay:String - full day of the week

function getWeekPeriodDate($startDate,$todayDate,$weeks,$wantDay){

  $startDate = date("Y-m-d", strtotime("next $wantDay" ,strtotime($startDate))); 

  $dayDiff = round((strtotime($startDate)-strtotime($todayDate))/(24*60*60),0);

  $weekPeriodDiff = abs(round($dayDiff/7/$weeks)*$weeks);

  return date("Y-m-d",strtotime($startDate . " + " . $weekPeriodDiff . " weeks"));

}



Usage :getWeekPeriodDate("2006-July-1","2007-Nov-5",8,"Tuesday")

returns : 2007-11-20 (which is the next Tuesday based on 8 week periods since the next Tuesday closest to the start date)

snobord787 at msn dot com
30-Aug-2007 01:06


I modified (erenezgu at gmail.com)'s code so you don't have to redirect but is stored in cookies.



<?php

if(empty($_COOKIE['offset'])) {

    // Javascript is our friend!

    $header='

<script type="text/javascript">

document.cookie="offset=" + ( (new Date()).getTimezoneOffset()*60)*(-1)-'.abs(date('Z')).';

</script>

';

}



// Example Usage

echo date('d/m/Y H:i:s', time()+$_COOKIE['offset'] );

?>

jasonlfunk (at) gmail dot com
11-Aug-2007 04:39


If there is an easier way to find the week of the month, let me know. Here is how I figured out how to do it;



date("W") - date("W",strtotime(date("F") . " 1st " . date("Y"))) + 1;

luis dot sv at gmail dot com
21-Jul-2007 03:00


In relation to soreenpk at yahoo dot com's message:



That code doesn't work for two dates with a difference larger than a year, for example:

$digest_date = "2006-04-14";

$date2="2007-04-15";

$date_diff = date("d",strtotime($date2)) - date("d",strtotime($digest_date));//$date_diff = 1

samuel at islabinaria dot com
16-Jul-2007 11:18


Here is a backward compatible version of dates_interconv

http://www.php.net/manual/en/function.date.php#71397

which also works with time (hours, minutes and seconds) and months in "M" format (three letters):



<?php

  /**

   mod of

   http://www.php.net/manual/en/function.date.php#71397

   * Converts a date and time string from one format to another (e.g. d/m/Y => Y-m-d, d.m.Y => Y/d/m, ...)

   *

   * @param string $date_format1

   * @param string $date_format2

   * @param string $date_str

   * @return string

  */

  function dates_interconv($date_format1, $date_format2, $date_str)

  {



      $base_struc     = split('[:/.\ \-]', $date_format1);

      $date_str_parts = split('[:/.\ \-]', $date_str );

     

      // print_r( $base_struc ); echo "\n"; // for testing

      // print_r( $date_str_parts ); echo "\n"; // for testing

     

      $date_elements = array();

     

      $p_keys = array_keys( $base_struc );

      foreach ( $p_keys as $p_key )

      {

          if ( !empty( $date_str_parts[$p_key] ))

          {

              $date_elements[$base_struc[$p_key]] = $date_str_parts[$p_key];

          }

          else

              return false;

      }

     

      // print_r($date_elements); // for testing

      

      if (array_key_exists('M', $date_elements)) {

        $Mtom=array(

          "Jan"=>"01",

          "Feb"=>"02",

          "Mar"=>"03",

          "Apr"=>"04",

          "May"=>"05",

          "Jun"=>"06",

          "Jul"=>"07",

          "Aug"=>"08",

          "Sep"=>"09",

          "Oct"=>"10",

          "Nov"=>"11",

          "Dec"=>"12",

        );

        $date_elements['m']=$Mtom[$date_elements['M']];

      }

      

      // print_r($date_elements); // for testing

     

      $dummy_ts = mktime(

        $date_elements['H'], 

        $date_elements['i'], 

        $date_elements['s'], 

        $date_elements['m'],

        $date_elements['d'],

        $date_elements['Y']

      );

     

      return date( $date_format2, $dummy_ts );

  }

?>



Usage:



<?php

  $df_src = 'd/m/Y H:i:s';

  $df_des = 'Y-m-d H:i:s';

 

  echo dates_interconv( $df_src, $df_des, '25/12/2005 23:59:59');

?>



Output:



2005-12-25 23:59:59

pierrotevrard at gmail dot com
03-Jul-2007 08:11


For people who used "z" format...



The real range of "z" key format is 0 to 365 (instead of 366) and "z" represent the number of spent days in the year.

See this examples :



<?php

define ("\n" , NL );

print '<pre>';



print '"z" format interpretation:' . NL . NL;



print 'On 0 timestamp: "' . date( 'z : Y-m-d' , 0 ) . '"' . NL;

//show: On 0 timestamp: "0 : 1970-01-01"



print 'On second unix day: "' . date( 'z : Y-m-d' , 3600*24 ) . '"' . NL;

//show: On second unix day: "1 : 1970-01-02"



print 'On the last day of a leap year: "' . date( 'z : Y-m-d' , mktime( 23, 59, 59, 12, 31, 2000 ) ) . '"' . NL;

//show: On the last day of a leap year: "365 : 2000-12-31"



print 'On the day after the last day of a leap year: "' . date( 'z : Y-m-d' , mktime( 23, 59, 59, 12, 31+1, 2000 ) ) . '"' . NL;

//show: On the day after the last day of a leap year: "0 : 2001-01-01"



print '</pre>';



?>

jcwebb at dicoe dot com
20-Jun-2007 02:48


i needed the day (eg. 27th) of the last Monday of a month

<?php

$d=cal_days_in_month(CAL_GREGORIAN,$m,$y); // days in month

if (date('l',mktime(0,0,0,$m,$d,$y))=='Monday'): $finalmonday=$d;

else: $finalmonday=date('d',strtotime('last Monday',mktime(0,0,0,$m,$d,$y))); // day(date) of last monday of month, eg 26

endif;

?>

this also works...

<?php

$finalmonday=date('d',strtotime('last Monday',mktime(0,0,0,$m,($d+1),$y)));

//the '$d+1' is to catch the last day IS a monday (eg. dec 2007)

?>



Hope it helps, BigJonMX

boris at psyonline dot ru
15-Jun-2007 12:05


<?php



/**

 * Get date in RFC3339

 * For example used in XML/Atom

 *

 * @param integer $timestamp

 * @return string date in RFC3339

 * @author Boris Korobkov

 * @see http://tools.ietf.org/html/rfc3339

 */

function date3339($timestamp=0) {



    if (!$timestamp) {

        $timestamp = time();

    }

    $date = date('Y-m-d\TH:i:s', $timestamp);



    $matches = array();

    if (preg_match('/^([\-+])(\d{2})(\d{2})$/', date('O', $timestamp), $matches)) {

        $date .= $matches[1].$matches[2].':'.$matches[3];

    } else {

        $date .= 'Z';

    }

    return $date;



}



?>

john at hotmail dot com
12-Jun-2007 10:55


Just a small addition to dmitriy. If the present date is in daylight saving time, and the date in the past is not, the result will not be a whole number by dividing by 86400. It will be something like 48.958333333. This is because the day in which it changes from normal to daylight saving time is one hour longer than normal (90000 secs) and the opposite is true when changing back (the day would be one hour shorter - 82800 secs).



If you want a whole number of days use the following instead:



<?php

$digest_date = "2007-01-01";

$date_diff = round( abs(strtotime(date('y-m-d'))-strtotime($digest_date)) / 86400, 0 );

?>

dmitriy dot yakovlev at gmail dot com
12-Jun-2007 12:55


soreenpk - the code snippet you posted will not find the day difference between two days that are not in the same month. This will: 



<?php

$digest_date = "2007-06-01";

$date_diff = abs(strtotime(date('y-m-d'))-strtotime($digest_date)) / 86400;

?>



86400 is the number of seconds in a day, so finding the date difference in seconds and converting to days will give true day difference between dates.  Cheers.

pburlandoA_Remove_TgmailDOTcom
21-May-2007 04:30


This is an implementation for days360 formula used in financial calc software, this asumes year with 360 days and months with 30 days. 



I am looking for a reliable function to add days to a date using 30[E]/360 format.



<?php

/* Calc days between two dates using the financial calendar

30/360 (usa) or 30E/360(european)<-default

$fecha1 and $fecha2 in format: aaaa-mm-dd

return days  or -1 in case of error. 



based on cost_analysis.py module Ver. 0.1 public domain, no license required by Harm Kirchhoff

*/

function days_360($fecha1,$fecha2,$europeo=true) {

  //try switch dates: min to max

  if( $fecha1 > $fecha2 ) {

    $temf = $fecha1; 

    $fecha1 = $fecha2;

    $fecha2 = $temf;

  }



  // get day month year...

  list($yy1, $mm1, $dd1) = explode('-', $fecha1);

  list($yy2, $mm2, $dd2) = explode('-', $fecha2);



  if( $dd1==31) { $dd1 = 30; }



  //checks according standars: 30E/360 or 30/360.

  if(!$europeo) {

    if( ($dd1==30) and ($dd2==31) ) {

      $dd2=30;

    } else {

      if( $dd2==31 ) {

        $dd2=30;

      }

    }

  }



  //check for invalid date

  if( ($dd1<1) or ($dd2<1) or ($dd1>30) or ($dd2>31) or 

      ($mm1<1) or ($mm2<1) or ($mm1>12) or ($mm2>12) or

      ($yy1>$yy2) ) {

    return(-1);

  }

  if( ($yy1==$yy2) and ($mm1>$mm2) ) { return(-1); }

  if( ($yy1==$yy2) and ($mm1==$mm2) and ($dd1>$dd2) ) { return(-1); }

  

  //Calc

  $yy = $yy2-$yy1;

  $mm = $mm2-$mm1;

  $dd = $dd2-$dd1;

  

  return( ($yy*360)+($mm*30)+$dd );

}



// usage:

echo days_360("2007-01-13","2007-05-20");



?>

fokeyjoe at themotto dot co dot uk
04-May-2007 01:52


Another method for getting close to ISO8601 using PHP4 (should cover all versions). This format gets you compliant RDF/RSS feed dates:



$sISO8601=date('Y-m-d\Th:i:s',$nTimestamp). substr_replace(date('O',$nTimestamp),':',3,0);



The main limitation I'm aware of is the non-compliant year around new year.

jonbarnett at gmail dot com
25-Apr-2007 04:37


To everyone who is posting functions to parse date strings and turn them into time stamps - please look at the strtotime() function.  It probably already does whatever you're writing a function to do.



To the person right below me: while your function might be an extremely small bit more efficient, strtotime() will work just fine.

dmitrid at dont_show dot com
11-Mar-2007 05:14


Note for wips week limits function:

I had to run it over 52 weeks of the year and it was very slow so I've modified to improve:

function week_limits($weekNumber, $year, $pattern)

{

    $pattern = ($pattern) ? $pattern : "m/d";

    $stday = 7 * $weekNumber - 7;

    $stDayNumber = date("w", mktime(0,0,0,1, 1+$stday, $year));

    $stUtime = mktime(0,0,0,1,1+$stday-$stDayNumber, $year);

    $start_time = date($pattern, $stUtime);

    $end_time = date($pattern, $stUtime+6*24*60*60);

   return array($start_time, $end_time);

}//week_limits()

marius at svr dot ro
06-Feb-2007 03:54


Re: steve at somejunkwelike dot com



I think this is a better function to find the business days between two dates. This function requires PHP 5.1.0.



<?php

//The function returns the no. of business days between two dates and it skeeps the holidays

function getWorkingDays($startDate,$endDate,$holidays){

    //The total number of days between the two dates. We compute the no. of seconds and divide it to 60*60*24

    //We add one to inlude both dates in the interval.

    $days = (strtotime($endDate) - strtotime($startDate)) / 86400 + 1;



    $no_full_weeks = floor($days / 7);

    $no_remaining_days = fmod($days, 7);



    //It will return 1 if it's Monday,.. ,7 for Sunday

    $the_first_day_of_week = date("N",strtotime($startDate));

    $the_last_day_of_week = date("N",strtotime($endDate));



    //The two can't be equal because the $no_remaining_days (the interval between $the_first_day_of_week and $the_last_day_of_week) is at most 6

    //In the first case the whole interval is within a week, in the second case the interval falls in two weeks.

    if ($the_first_day_of_week < $the_last_day_of_week){

        if ($the_first_day_of_week <= 6 && 6 <= $the_last_day_of_week) $no_remaining_days--;

        if ($the_first_day_of_week <= 7 && 7 <= $the_last_day_of_week) $no_remaining_days--;

    }

    else{

        if ($the_first_day_of_week <= 6) $no_remaining_days--;

        //In the case when the interval falls in two weeks, there will be a Sunday for sure

        $no_remaining_days--;

    }



    //The no. of business days is: (number of weeks between the two dates) * (5 working days) + the remainder

    $workingDays = $no_full_weeks * 5 + $no_remaining_days;



    //We subtract the holidays

    foreach($holidays as $holiday){

        $time_stamp=strtotime($holiday);

        //If the holiday doesn't fall in weekend

        if (strtotime($startDate) <= $time_stamp && $time_stamp <= strtotime($endDate) && date("N",$time_stamp) != 6 && date("N",$time_stamp) != 7)

            $workingDays--;

    }



    return $workingDays;

}



//Example:



$holidays=array("2006-12-25","2006-12-26","2007-01-01");



echo getWorkingDays("2006-12-22","2007-01-06",$holidays)

// => will return 8

?>