Things to be aware of when using week numbers with years.
<?php
echo date("YW", strtotime("2011-01-07")); // gives 201101
echo date("YW", strtotime("2011-12-31")); // gives 201152
echo date("YW", strtotime("2011-01-01")); // gives 201152 too
?>
BUT
<?php
echo date("oW", strtotime("2011-01-07")); // gives 201101
echo date("oW", strtotime("2011-12-31")); // gives 201152
echo date("oW", strtotime("2011-01-01")); // gives 201052 (Year is different than previous example)
?>
Reason:
Y is year from the date
o is ISO-8601 year number
W is ISO-8601 week number of year
Conclusion:
if using 'W' for the week number use 'o' for the year.
date
(PHP 4, PHP 5, PHP 7)
date — Formatta una data o orario locale
Descrizione
string date
( string
$format
[, int $timestamp = time()
] )
Restituisce una stringa formattata in accordo con il formato della stringa data usando
l'intero timestamp dato o l'orario corrente
se nessun timestamp è dato. In altre parole, timestamp
è opzionale e di default prende il valore di time().
Elenco dei parametri
-
format -
Il formato della data da produrre come string. Vedere le opzioni di formattazione sottostanti. Ci sono anche tante costanti delle date predefinite che possono essere usate al loro posto, così per esempio
DATE_RSScontiene la stringa dal formato 'D, d M Y H:i:s'.I seguenti caratteri sono riconosciuti nel parametro stringa formatCarattere del formatDescrizione Esempio di valori restituiti Giorno --- --- d Giorno del mese, 2 cifre con zero iniziali 01 a 31 D Una rappresentazione testuale di un giorno, tre lettere Mon a Sun j Giorno del mese senza gli zero iniziali 1 a 31 l ('L' minuscola) Una rappresentazione testuale completa del giorno della settimana Sunday a Saturday N Rappresentazione numerica ISO-8601 del giorno della settimana (aggiunto in PHP 5.1.0) 1 (per Lunedì) a 7 (per Domenica) S Suffisso ordinale inglese per il giorno del mese, 2 caratteri st, nd, rd o th. Funziona bene con j w Rappresentazione numerica del giorno della settimana 0 (per Domenica) a 6 (per Sabato) z Il giorno dell'anno (partendo da 0) 0 a 365 Settimana --- --- W Numero della settimana dell'anno ISO-8601, le settimane iniziano di Lunedì (aggiunto in PHP 4.1.0) Esempio: 42 (la 42esima settimana nell'anno) Mese --- --- F Una rappresentazione testuale completa di un mese, come January o March January a December m Rappresentazione numerica di un mese, con gli zero iniziali 01 a 12 M Una piccola rappresentazione testuale di un mese, tre lettere Jan a Dec n Rappresentazione numerica di un mese, senza gli zero iniziali 1 a 12 t Numero di giorni nel dato mese 28 a 31 Anno --- --- L Se si tratta di un anno bisestile 1 se è un anno bisestile, 0 in caso contrario. o Il numero dell'anno ISO-8601. Questo ha lo stesso valore di Y, eccetto che se il numero della settimana ISO (W) appartiene all'anno precedente o successivo, viene invece utilizzato quell'anno. (aggiunto in PHP 5.1.0) Esempi: 1999 o 2003 Y Una rappresentazione numerica completa di un anno, 4 cifre Esempi: 1999 o 2003 y Una rappresentazione a due cifre di un anno Esempi: 99 o 03 Orario --- --- a Ante meridiem e Post meridiem in minuscole am o pm A Ante meridiem e Post meridiem in maiuscole AM o PM B Orario di Internet Swatch 000 a 999 g Formato a 12 ore di un'ora senza gli zero iniziali 1 a 12 G Formato a 24 ore di un'ora senza gli zero iniziali 0 a 23 h Formato a 12 ore di un'ora con gli zero iniziali 01 a 12 H Formato a 24 ore di un'ora con gli zero iniziali 00 a 23 i Minuti con gli zero iniziali 00 a 59 s Secondi, con gli zero iniziali 00 a 59 u Microsecondi (aggiunto in PHP 5.2.2). Notare che date() genererà sempre 000000 dato che prende un parametro integer, mentre DateTime::format() supporta i microsecondi se DateTime è stato creato con i microsecondi. Esempio: 654321 Fuso orario --- --- e Identificatore del fuso orario (aggiunto in PHP 5.1.0) Esempi: UTC, GMT, Atlantic/Azores I (i maiuscola) Se la data è o no in ora legale 1 se è ora legale, 0 in caso contrario. O Differenza dall'ora di Greenwich (GMT) in ore Esempio: +0200 P Differenza dall'ora di Greenwich (GMT) con due punti tra ore e minuti (aggiunto in PHP 5.1.3) Esempio: +02:00 T Abbreviazione del fuso orario Esempio: EST, MDT ... Z Differenza del fuso orario in secondi. La differenza per i fusi orari ad ovest di UTC è sempre negativa, e per quelli all'est di UTC è sempre positiva. -43200 a 50400 Data/Ora Completa --- --- c Data ISO 8601 (aggiunta in PHP 5) 2004-02-12T15:19:21+00:00 r Data formattata in » RFC 2822 Esempio: Thu, 21 Dec 2000 16:01:07 +0200 U Il numero di secondi dalla Unix Epoch (Gennaio 1 1970 00:00:00 GMT) Vedere anche time() I caratteri non riconosciuti nella stringa formato saranno stampati così come sono. Il formato Z restituirà sempre 0 quando si utilizza gmdate().
Nota:
Poichè questa funzione accetta solo timestamp integer il carattere di formato u è utile solo quando si utilizza la funzione date_format() con i timestamp basati sull'utente creati con date_create().
-
timestamp -
Il parametro opzionale
timestampè un integer timestamp Unix che ha come default l'ora locale attuale se untimestampnon è fornito. In altre parole, ha come default il valore di time().
Valori restituiti
Restituisce una stringa data formattata. Se viene utilizzato un valore non numerico per
timestamp, viene restituito FALSE e viene
emesso un errore di livello E_WARNING.
Errori/Eccezioni
Ogni chiamata a una funzione data/ora genera un E_NOTICE
se il time zone non è valido, e/o un messaggio E_STRICT
o E_WARNING
se si usano le impostazioni di sistema o la variabile d'ambiente TZ.
Vedere anche date_default_timezone_set()
Log delle modifiche
| Versione | Descrizione |
|---|---|
| 5.1.0 | L'intervallo valido di un timestamp è tipicamente da Ven, 13 Dec 1901 20:45:54 GMT a Mar, 19 Gen 2038 03:14:07 GMT. (Queste sono le date che corrispondono al valore minimo e massimo per un intero con segno a 32-bit). Tuttavia, prima di PHP 5.1.0 questo intervallo era limitato da 01-01-1970 a 19-01-2038 su alcuni sistemi (es. Windows). |
| 5.1.0 |
Ora emette gli errori time zone |
| 5.1.1 |
Ci sono delle costanti utili
dei formati di data/ora standard che possono essere usate per specificare il
parametro format.
|
Esempi
Example #1 Esempi di date()
<?php
// imposta il fuso orario di default da utilizzare. Disponibile da PHP 5.1
date_default_timezone_set('UTC');
// Stampa qualcosa di simile a: Monday
echo date("l");
// Stampa qualcosa di simile a: Monday 8th of August 2005 03:12:46 PM
echo date('l jS \of F Y h:i:s A');
// Stampa: July 1, 2000 is on a Saturday
echo "July 1, 2000 is on a " . date("l", mktime(0, 0, 0, 7, 1, 2000));
/* usa le costanti nel parametro format */
// stampa qualcosa di simile a: Wed, 25 Sep 2013 15:28:57 -0700
echo date(DATE_RFC2822);
// stampa qualcosa di simile a: 2000-07-01T00:00:00+00:00
echo date(DATE_ATOM, mktime(0, 0, 0, 7, 1, 2000));
?>
È possibile evitare che un carattere riconosciuto nella stringa formato venga espanso effettuando l'escape di esso anteponendo un backslash. Se il carattere con un backslash è già una sequenza speciale, potrebbe essere necessario effettuare l'escape anche del backslash.
Example #2 Effettuare l'escape dei caratteri in date()
<?php
// stampa qualcosa di simile a: Wednesday the 15th
echo date('l \t\h\e jS');
?>
È possibile utilizzare insieme date() e mktime() per trovare date nel futuro o nel passato.
Example #3 Esempio di date() e di mktime()
<?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);
?>
Nota:
Questo può essere più affidabile rispetto che semplicemente aggiungere o sottrarre il numero di secondi in un giorno o in un mese ad un timestamp a causa dell'ora legale.
Alcuni esempi della formattazione date(). Notare che si dovrebbe effettuare l'escape di qualsiasi altro carattere, come tutti quelli che attualmente hanno un significato speciale produrranno risultati indesiderati, e ad altri caratteri potrebbe essere assegnato un significato nelle versioni future di PHP. Quando si effettua l'escape, assicurarsi di usare gli apici singoli in modo da evitare che i caratteri come \n divengano nuove linee.
Example #4 Formattazione di date()
<?php
// Assumendo che oggi sia Il 10 Marzo, 2001, 5:16:18 pm, e che noi siamo nel
// Fuso Orario Mountain Standard Time (MST)
$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'); // 05-16-18, 10-03-01, 1631 1618 6 Satpm01
$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 17:16:18 MST 2001
$today = date('H:m:s \m \i\s\ \m\o\n\t\h'); // 17:03:18 m is month
$today = date("H:i:s"); // 17:16:18
$today = date("Y-m-d H:i:s"); // 2001-03-10 17:16:18 (the MySQL DATETIME format)
?>
Per formattare le date in altri lingue, si dovrebbero utilizzare le funzioni setlocale() e strftime() al posto di date().
Note
Nota:
Per generare un timestamp da una stringa che rappresenta la data, si può essere in grado di utilizzare strtotime(). Inoltre, alcuni database hanno delle funzioni per convertire i loro formati data in timestamp (come la funzione » UNIX_TIMESTAMP di MySQL).
Suggerimento
Il timestamp dell'inizio della richiesta è disponibile in $_SERVER['REQUEST_TIME'] da PHP 5.1.
Vedere anche:
- gmdate() - Formatta una data/ora GMT/UTC
- idate() - Format a local time/date as integer
- getdate() - Restituisce informazioni sulla data/orario
- getlastmod() - Restituisce la data dell'ultima modifica alla pagina
- mktime() - Restituisce la UNIX timestamp per una data
- strftime() - Formatta una data/orario locale accordandola/o alle impostazioni locali according to locale settings
- time() - Restituisce l'attuale UNIX timestamp
- strtotime() - Analizza qualsiasi descrizione datetime testuale inglese e la converte in uno Unix timestamp
- Costanti di DateTime Predefinite
add a note
User Contributed Notes 33 notes
Jimmy ¶
6 years ago
tekintian at gmail dot com ¶
2 months ago
<?php
/**
* 计算两个日期相隔时间：年、月、日、时、分、秒 总计天数
* @author TekinTian <tekintian#gmail.com>
* @param string $start_time 开始时间 必须 [格式如：2011-11-5 10:01:01]
* @param string $end_time 结束时间 选填，不提供默认未当前时间 [格式如：2012-12-01 10:01:01]
* @return array Array ( [y] => 年 [m] => 月 [d] => 日 [h] => 时 [i] => 分 [s] => 秒 [a] => 合计天数 )
*/
function get_date_diff($start_time,$end_time=''){
$end_time = ($end_time=='')?date("Y-m-d H:i:s"):$end_time;
$datetime1 = new \DateTime($start_time);
$datetime2 = new \DateTime($end_time);
$interval = $datetime1->diff($datetime2);
$time['y'] = $interval->format('%y');
$time['m'] = $interval->format('%m');
$time['d'] = $interval->format('%d');
$time['h'] = $interval->format('%H');
$time['i'] = $interval->format('%i');
$time['s'] = $interval->format('%s');
$time['a'] = $interval->format('%a'); // 两个时间相差总天数
return $time;
}
//demo use
// echo '<pre>';
print_r(get_date_diff('2016-10-15 10:01:56'));
// echo '</pre>';
bruslbn at gmail dot com ¶
3 months ago
In order to define leap year you must considre not only that year can be divide by 4!
The correct alghoritm is:
if (year is not divisible by 4) then (it is a common year)
else if (year is not divisible by 100) then (it is a leap year)
else if (year is not divisible by 400) then (it is a common year)
else (it is a leap year)
So the code should look like this:
if($year%4 == 0 && $year%100 != 0) {
$leapYear = 1;
} elseif($year%400 == 0) {
$leapYear = 1;
} else {
$leapYear = 0;
}
adityabhai at gmail dot com ¶
4 years ago
For Microseconds, we can get by following:
echo date('Ymd His'.substr((string)microtime(), 1, 8).' e');
Thought, it might be useful to someone !
FiraSEO ¶
5 years ago
this how you make an HTML5 <time> tag correctly
<?php
echo '<time datetime="'.date('c').'">'.date('Y - m - d').'</time>';
?>
in the "datetime" attribute you should put a machine-readable value which represent time , the best value is a full time/date with ISO 8601 ( date('c') ) ,,, the attr will be hidden from users
and it doesn't really matter what you put as a shown value to the user,, any date/time format is okay !
This is very good for SEO especially search engines like Google .
ivijan dot stefan at gmail dot com ¶
3 years ago
If you have a problem with the different time zone, this is the solution for that.
<?php
// first line of PHP
$defaultTimeZone='UTC';
if(date_default_timezone_get()!=$defaultTimeZone)) date_default_timezone_set($defaultTimeZone);
// somewhere in the code
function _date($format="r", $timestamp=false, $timezone=false)
{
$userTimezone = new DateTimeZone(!empty($timezone) ? $timezone : 'GMT');
$gmtTimezone = new DateTimeZone('GMT');
$myDateTime = new DateTime(($timestamp!=false?date("r",(int)$timestamp):date("r")), $gmtTimezone);
$offset = $userTimezone->getOffset($myDateTime);
return date($format, ($timestamp!=false?(int)$timestamp:$myDateTime->format('U')) + $offset);
}
/* Example */
echo 'System Date/Time: '.date("Y-m-d | h:i:sa").'<br>';
echo 'New York Date/Time: '._date("Y-m-d | h:i:sa", false, 'America/New_York').'<br>';
echo 'Belgrade Date/Time: '._date("Y-m-d | h:i:sa", false, 'Europe/Belgrade').'<br>';
echo 'Belgrade Date/Time: '._date("Y-m-d | h:i:sa", 514640700, 'Europe/Belgrade').'<br>';
?>
This is the best and fastest solution for this problem. Working almost identical to date() function only as a supplement has the time zone option.
matthew dot hotchen at worldfirst dot com ¶
4 years ago
FYI: there's a list of constants with predefined formats on the DateTime object, for example instead of outputting ISO 8601 dates with:
<?php
echo date('c');
?>
or
<?php
echo date('Y-m-d\TH:i:sO');
?>
You can use
<?php
echo date(DateTime::ISO8601);
?>
instead, which is much easier to read.
david dot thomas at elliott-thomas dot com dot au ¶
1 year ago
Prior to PHP 5.6.23, Relative Formats for the start of the week aligned with PHP's (0=Sunday,6=Saturday). Since 5.6.23, Relative Formats for the start of the week align with ISO-8601 (1=Monday,7=Sunday). (http://php.net/manual/en/datetime.formats.relative.php)
This can produce different, and seemingly incorrect, results depending on your PHP version and your choice of 'w' or 'N' for the Numeric representation of the day of the week:
<?php
echo "Today is Sun 2 Oct 2016, day ",date('w',strtotime('2016-10-02'))," of this week. ";
echo "Day ",date('w',strtotime('2016-10-02 Monday next week'))," of next week is ",date('d M Y',strtotime('2016-10-02 Monday next week')),"<br />";
echo "Today is Sun 2 Oct 2016, day ",date('N',strtotime('2016-10-02'))," of this week. ";
echo "Day ",date('w',strtotime('2016-10-02 Monday next week'))," of next week is ",date('d M Y',strtotime('2016-10-02 Monday next week'));
?>
Prior to PHP 5.6.23, this results in:
Today is Sun 2 Oct 2016, day 0 of this week. Day 1 of next week is 10 Oct 2016
Today is Sun 2 Oct 2016, day 7 of this week. Day 1 of next week is 10 Oct 2016
Since PHP 5.6.23, this results in:
Today is Sun 2 Oct 2016, day 0 of this week. Day 1 of next week is 03 Oct 2016
Today is Sun 2 Oct 2016, day 7 of this week. Day 1 of next week is 03 Oct 2016
Anonymous ¶
2 years ago
If timestamp is a string, date converts it to an integer in a possibly unexpected way:
<?php
echo (int)'0x10'; //0
echo intval('0x10'); //0
echo date('s', '0x10'); //gives 16
//however, no octal conversion:
echo date('s', '010'); //gives 10
?>
(PHP 5.6.16)
Anonymous ¶
4 years ago
It's common for us to overthink the complexity of date/time calculations and underthink the power and flexibility of PHP's built-in functions. Consider http://php.net/manual/en/function.date.php#108613
<?php
function get_time_string($seconds)
{
return date('H:i:s', strtotime("2000-01-01 + $seconds SECONDS"));
}
ccb_bc at hotmail dot com ¶
3 months ago
<?php
/**
* Convert Date formats:
*/
// $date '1989/11/25'
// $date '1989-11-25'
// $date '1989.11.25'
if(preg_match("/^[0-9]{4}(\/|-|.)(0[1-9]|1[0-2])(\/|-|.)(0[1-9]|[1-2][0-9]|3[0-1])$/", $date)){
return substr($date, 8, 2).substr($date, 7,1).substr($date, 5,2).substr($date, 4,1).substr($date, 0,4);
// Result: '25/11/1989' - OR - '25-11-1989' - OR - '25.11.1989'
}
// $date = '25/11/1989'
// $date = '25-11-1989'
// $date = '25.11.1989'
if(preg_match("/^(0[1-9]|[1-2][0-9]|3[0-1])(\/|-|.)(0[1-9]|1[0-2])(\/|-|.)[0-9]{4}$/", $date)){
return substr($date, 6, 4).substr($date, 5,1).substr($date, 3,2).substr($date, 2,1).substr($date, 0,2);
// Result: '1989/11/25' - OR - '1989-11-25' - OR - '1989.11.25'
}
?>
bruslbn at gmail dot com ¶
3 months ago
In order to define leap year you must considre not only that year can be divide by 4!
The correct alghoritm is:
if (year is not divisible by 4) then (it is a common year)
else if (year is not divisible by 100) then (it is a leap year)
else if (year is not divisible by 400) then (it is a common year)
else (it is a leap year)
So the code should look like this:
if($year%4 == 0 && $year%100 != 0) {
$leapYear = 1;
} elseif($year%400 == 0) {
$leapYear = 1;
} else {
$leapYear = 0;
}
mel dot boyce at gmail dot com ¶
12 years ago
I've been flicking through the comments looking for some succinct date code and have noticed an alarming number of questions and over-burdened examples related to date mathematics. One of the most useful skills you can utilize when performing date math is taking full advantage of the UNIX timestamp. The UNIX timestamp was built for this kind of work.
An example of this relates to a comment made by james at bandit-dot-co-dot-en-zed. James was looking for a way to calculate the number of days which have passed since a certain date. Rather than using mktime() and a loop, James can subtract the current timestamp from the timestamp of the date in question and divide that by the number of seconds in a day:
<?php
$days = floor((time() - strtotime("01-Jan-2006"))/86400);
print("$days days have passed.\n");
?>
Another usage could find itself in a class submitted by Kyle M Hall which aids in the creation of timestamps from the recent past for use with MySQL. Rather than the looping and fine tuning of a date, Kyle can use the raw UNIX timestamps (this is untested code):
<?php
$ago = 14; // days
$timestamp = time() - ($ago * 86400);
?>
Hopefully these two examples of "UNIX-style" timestamp usage will help those finding date mathematics more elusive than it should be.
olivertappin at gmail dot com ¶
1 month ago
If looking for a simple way to return the week number, using Sunday as the first day of the week, please bear in mind you will need to cater for the addition when you reach the end of the year.
<?php
function getSundayWeekNumber(\DateTimeInterface $date): int
{
$weekNumber = (int)$date->format('W');
if ($date->format('w') === '0') { // Sunday
$weekNumber += 1;
if (53 === $weekNumber) { // If the week is now 53, subtract 52
$weekNumber -= 52;
}
}
return $weekNumber;
}
rc at macshot dot de ¶
1 year ago
At least in PHP 5.5.38 date('j.n.Y', 2222222222) gives a result of 2.6.2040.
So date is not longer limited to the minimum and maximum values for a 32-bit signed integer as timestamp.
bakerj417 at gmail dot com ¶
6 years ago
If you are having an issue getting u to work so is everyone else. The solution that I am using which I found on another site(so not taking credit) is to use this:
date("Y/m/d H:i:s"). substr((string)microtime(), 1, 6);
that will give you:
yyyy/mm/dd hh:ii:ss.uuuuuu
hope this helps someone in need!
thanks all
Just.Kevin ¶
8 years ago
In order to determine if a year is a leap year an earlier poster suggested simply checking to see if the year is a multiple of four:
<?php
function is_leapyear_broken($year = 2004) {
return ($year%4)==0;
}
?>
While this will work for the majority of years it will not work on years that are multiples of 100 but not multiples of 400 i.e.(2100).
A function not using php's date() function that will also account for this small anomaly in leap years:
<?php
function is_leapyear_working($year = 2004) {
if((($year%4==0) && ($year%100!=0)) || $year%400==0) {
return true;
}
return false;
}
?>
While is_leapyear_working will not return true for the few non-leap years divisible by four I couldn't tell you if this is more or less efficient than using php's date() as an even earlier poster suggested:
<?php
function is_leapyear($year = 2004) {
$is_leap = date('L', strtotime("$year-1-1"));
return $is_leap;
}
?>
SpikeDaCruz ¶
12 years ago
The following function will return the date (on the Gregorian calendar) for Orthodox Easter (Pascha). Note that incorrect results will be returned for years less than 1601 or greater than 2399. This is because the Julian calendar (from which the Easter date is calculated) deviates from the Gregorian by one day for each century-year that is NOT a leap-year, i.e. the century is divisible by 4 but not by 10. (In the old Julian reckoning, EVERY 4th year was a leap-year.)
This algorithm was first proposed by the mathematician/physicist Gauss. Its complexity derives from the fact that the calculation is based on a combination of solar and lunar calendars.
<?php
function getOrthodoxEaster($date){
/*
Takes any Gregorian date and returns the Gregorian
date of Orthodox Easter for that year.
*/
$year = date("Y", $date);
$r1 = $year % 19;
$r2 = $year % 4;
$r3 = $year % 7;
$ra = 19 * $r1 + 16;
$r4 = $ra % 30;
$rb = 2 * $r2 + 4 * $r3 + 6 * $r4;
$r5 = $rb % 7;
$rc = $r4 + $r5;
//Orthodox Easter for this year will fall $rc days after April 3
return strtotime("3 April $year + $rc days");
}
?>
Bas Vijfwinkel ¶
6 years ago
Note that some formatting options are different from MySQL.
For example using a 24 hour notation without leading zeros is the option '%G' in PHP but '%k' in MySQL.
When using dynamically generated date formatting string, be careful to generate the correct options for either PHP or MySQL.
Charlie ¶
2 years ago
For HTML5 datetime-local HTML input controls (http://www.w3.org/TR/html-markup/input.datetime-local.html) use format example: 1996-12-19T16:39:57
To generate this, escape the 'T', as shown below:
<?php
date('Y-m-d\TH:i:s');
?>
ghotinet ¶
7 years ago
Most spreadsheet programs have a rather nice little built-in function called NETWORKDAYS to calculate the number of business days (i.e. Monday-Friday, excluding holidays) between any two given dates. I couldn't find a simple way to do that in PHP, so I threw this together. It replicates the functionality of OpenOffice's NETWORKDAYS function - you give it a start date, an end date, and an array of any holidays you want skipped, and it'll tell you the number of business days (inclusive of the start and end days!) between them.
I've tested it pretty strenuously but date arithmetic is complicated and there's always the possibility I missed something, so please feel free to check my math.
The function could certainly be made much more powerful, to allow you to set different days to be ignored (e.g. "skip all Fridays and Saturdays but include Sundays") or to set up dates that should always be skipped (e.g. "skip July 4th in any year, skip the first Monday in September in any year"). But that's a project for another time.
<?php
function networkdays($s, $e, $holidays = array()) {
// If the start and end dates are given in the wrong order, flip them.
if ($s > $e)
return networkdays($e, $s, $holidays);
// Find the ISO-8601 day of the week for the two dates.
$sd = date("N", $s);
$ed = date("N", $e);
// Find the number of weeks between the dates.
$w = floor(($e - $s)/(86400*7)); # Divide the difference in the two times by seven days to get the number of weeks.
if ($ed >= $sd) { $w--; } # If the end date falls on the same day of the week or a later day of the week than the start date, subtract a week.
// Calculate net working days.
$nwd = max(6 - $sd, 0); # If the start day is Saturday or Sunday, add zero, otherewise add six minus the weekday number.
$nwd += min($ed, 5); # If the end day is Saturday or Sunday, add five, otherwise add the weekday number.
$nwd += $w * 5; # Add five days for each week in between.
// Iterate through the array of holidays. For each holiday between the start and end dates that isn't a Saturday or a Sunday, remove one day.
foreach ($holidays as $h) {
$h = strtotime($h);
if ($h > $s && $h < $e && date("N", $h) < 6)
$nwd--;
}
return $nwd;
}
$start = strtotime("1 January 2010");
$end = strtotime("13 December 2010");
// Add as many holidays as desired.
$holidays = array();
$holidays[] = "4 July 2010"; // Falls on a Sunday; doesn't affect count
$holidays[] = "6 September 2010"; // Falls on a Monday; reduces count by one
echo networkdays($start, $end, $holidays); // Returns 246
?>
Or, if you just want to know how many work days there are in any given year, here's a quick function for that one:
<?php
function workdaysinyear($y) {
$j1 = mktime(0,0,0,1,1,$y);
if (date("L", $j1)) {
if (date("N", $j1) == 6)
return 260;
elseif (date("N", $j1) == 5 or date("N", $j1) == 7)
return 261;
else
return 262;
}
else {
if (date("N", $j1) == 6 or date("N", $j1) == 7)
return 260;
else
return 261;
}
}
?>
Tim Connolly ¶
5 years ago
Here's my solution for looking up the month number by name (used when parsing an 'ls'):
<?php
for($m=1;$m<=12;$m++){
$month=date("M",mktime(0,0,0,$m,1,2000));
$mon["$month"]=$m;
}
?>
Hayley Watson ¶
1 year ago
If you see the number 86400 in a date calculation, think very hard before deciding that it is correct. Not all days have 86,400 seconds in them. In many places, some days have only 82,800 seconds and some have 90,000. Occasionally, there are even fewer or even more.
Assuming that now plus 86,400 seconds is equivalent to some time tomorrow can sometimes be wrong. It might actually be the day after tomorrow or still today.
It's called Daylight Saving.
Anonymous ¶
4 years ago
To quickly convert date("N") to a 0 based index with Sunday being represented as 0, you can run it against modulus 7:
<?php
$first_of_month_index = date('N', strtotime('4/1/1990')) % 7;
?>
eduardo at digmotor dot com dot br ¶
9 years ago
Thanks to tcasparr at gmail dot com for the great idea (at least for me) ;)
I changed the code a little to replicate the functionality of date_parse_from_format, once I don't have PHP 5.3.0 yet. This might be useful for someone. Hope you don't mind changing your code tcasparr at gmail dot com.
<?php
/*******************************************************
* Simple function to take in a date format and return array of associated
* formats for each date element
*
* @return array
* @param string $strFormat
*
* Example: Y/m/d g:i:s becomes
* Array
* (
* [year] => Y
* [month] => m
* [day] => d
* [hour] => g
* [minute] => i
* [second] => s
* )
*
* This function is needed for PHP < 5.3.0
********************************************************/
function dateParseFromFormat($stFormat, $stData)
{
$aDataRet = array();
$aPieces = split('[:/.\ \-]', $stFormat);
$aDatePart = split('[:/.\ \-]', $stData);
foreach($aPieces as $key=>$chPiece)
{
switch ($chPiece)
{
case 'd':
case 'j':
$aDataRet['day'] = $aDatePart[$key];
break;
case 'F':
case 'M':
case 'm':
case 'n':
$aDataRet['month'] = $aDatePart[$key];
break;
case 'o':
case 'Y':
case 'y':
$aDataRet['year'] = $aDatePart[$key];
break;
case 'g':
case 'G':
case 'h':
case 'H':
$aDataRet['hour'] = $aDatePart[$key];
break;
case 'i':
$aDataRet['minute'] = $aDatePart[$key];
break;
case 's':
$aDataRet['second'] = $aDatePart[$key];
break;
}
}
return $aDataRet;
}
?>
Also, if you need to change the format of dates:
<?php
function changeDateFormat($stDate,$stFormatFrom,$stFormatTo)
{
// When PHP 5.3.0 becomes available to me
//$date = date_parse_from_format($stFormatFrom,$stDate);
//For now I use the function above
$date = dateParseFromFormat($stFormatFrom,$stDate);
return date($stFormatTo,mktime($date['hour'],
$date['minute'],
$date['second'],
$date['month'],
$date['day'],
$date['year']));
}
?>
Anonymous ¶
9 years ago
Correct format for a MySQL DATETIME column is
<?php $mysqltime = date ("Y-m-d H:i:s", $phptime); ?>
erick900623 at gmail dot com ¶
6 months ago
Ayuda...
Tengo una fecha asignada con la function date("w"), y exactamente a las 5 pm la fecha cambia al siguiente dia. Ej
date("w") - Lunes
y a las 5pm del Lunes cambia a Martes.
Que puede estar pasando
bruslbn at gmail dot com ¶
3 months ago
In order to define leap year you must considre not only that year can be divide by 4!
The correct alghoritm is:
if (year is not divisible by 4) then (it is a common year)
else if (year is not divisible by 100) then (it is a leap year)
else if (year is not divisible by 400) then (it is a common year)
else (it is a leap year)
So the code should look like this:
if($year%4 == 0 && $year%100 != 0) {
$leapYear = 1;
} elseif($year%400 == 0) {
$leapYear = 1;
} else {
$leapYear = 0;
}
@PeteWilliams ¶
7 years ago
If you want to use HTML5's <date> tag, the following code will generate the machine-readable value for the 'datetime' attribute:
<?php
/**
* formats the date passed into format required by 'datetime' attribute of <date> tag
* if no intDate supplied, uses current date.
* @param intDate integer optional
* @return string
**/
function getDateTimeValue( $intDate = null ) {
$strFormat = 'Y-m-d\TH:i:s.uP';
$strDate = $intDate ? date( $strFormat, $intDate ) : date( $strFormat ) ;
return $strDate;
}
echo getDateTimeValue();
?>
rico at redant dot nl ¶
9 months ago
Since PHP 5.6.23 en 7.0.8 the support for requesting the weeknumber for a given date, where the first day of the week is Sunday, has been removed.
For those of us still needing it, here is simple hack to get the job done.
private function getWeeknumberSundayFirstDayOfWeek(\DateTimeInterface $date)
{
if ($date->format('w') === 0) // Sunday
return (int)$date->format('W') - 1;
return (int)$date->format('W');
}
Al Roker ¶
2 years ago
When using 'U' to return a UNIX time stamp, you may not get what you expect. In the following example, we try to get the current Unix time stamp for a user in a different timezone.
<?php
// Doesn't work
$timezone = new \DateTimeZone($userTimeZone);
$date = new \DateTime('@' . time(), $timezone);
$date->setTimezone($timezone);
$now = $date->format('U');
?>
$now will return the same (the server's current) Unix time stamp regardless which timezone your user is in.
To get the actual Unix time stamp based on a time zone, replace format('U') as in the following example;
<?php
// This works
$timezone = new \DateTimeZone($userTimeZone);
$date = new \DateTime('@' . time(), $timezone);
$date->setTimezone($timezone);
$now = $date->getTimestamp() + $date->getOffset();
?>
crackbeforesoft at gmail dot com ¶
7 months ago
I am glad and wonder about the topic creation. I am visiting this page from a long time ago. This is totally perspective clear ideas. This is sure that the information you shared is clearly identive and fabulous for keeping it in minds. http://crackswar.com/audacity-pro-crack/
crackbeforesoft at gmail dot com ¶
7 months ago
I am glad and wonder about the topic creation. I am visiting this page from a long time ago. This is totally perspective clear ideas. This is sure that the information you shared is clearly identive and fabulous for keeping it in minds. http://crackswar.com/audacity-pro-crack/
