date_timezone_set
here is a simple code to print the time according to the clients timezone offset. This code gets the clients timezone with javascript and redirects the page to itself with timezone offset as a parameter.
clienttime.php :
<?php
if ( isset($_GET['clientGMT']) ){
$clientGMT=intval( $_GET['clientGMT'] );
$serverGMT=intval( date('Z') );
echo date('H:i:s',time()+$clientGMT-$serverGMT);
}
else {
?>
<SCRIPT TYPE="text/javascript">
<!--
var clientGMT=( (new Date()).getTimezoneOffset()*60)*(-1) ;//client timezone offset in seconds
document.location='clienttime.php?clientGMT='+clientGMT ;
//->
</SCRIPT>
<?php
}
?>
date
(PHP 4, PHP 5)
date — Formatiert ein(e) angegebene(s) Ortszeit/Datum
Beschreibung
string date
( string
$format
[, int $timestamp = time()
] )
Gibt einen formatierten String anhand eines vorzugebenden Musters
zurück. Dabei wird entweder der angegebene
Timestamp oder die gegenwärtige lokale Zeit berücksichtigt,
wenn kein Timestamp angegegeben wird. Mit anderen Worten ausgedrückt: der Parameter
Timestamp ist optional und falls dieser nicht angegeben wird,
wird der Wert der Funktion time() angenommen.
Parameter-Liste
-
format -
Das Muster des auszugebenden Datums-/Zeit-String. Unten sind die verfügbaren Formatierungsoptionen angegeben. Es gibt auch verschiedene vordefinierte Konstanten, die verwendet werden können, z.B. enthält
DATE_RSSdas Formatierungsmuster 'D, d M Y H:i:s'.Die folgenden Zeichen werden im Parameter FormaterkanntFormat-ZeichenBeschreibung Beispiel für Rückgabewerte Tag --- --- d Tag des Monats, 2-stellig mit führender Null 01 bis 31 D Wochentag, gekürzt auf drei Buchstaben Mon bis Sun j Tag des Monats ohne führende Nullen 1 bis 31 l (kleines 'L') Ausgeschriebener Wochentags Sunday bis Saturday N Numerische Repräsentation des Wochentages gemäß ISO-8601 (in PHP 5.1.0 hinzugefügt) 1 (für Montag) bis 7 (für Sonntag) S Anhang der englischen Aufzählung für einen Monatstag, zwei Zeichen st, nd, rd oder th. Zur Verwendung mit j empfohlen. w Numerischer Tag einer Woche 0 (für Sonntag) bis 6 (für Samstag) z Der Tag des Jahres (von 0 beginnend) 0 bis365 Woche --- --- W ISO-8601 Wochennummer des Jahres, die Woche beginnt am Montag (hinzugefügt in PHP 4.1.0) Beispiel: 42 (die 42. Woche im Jahr) Monat --- --- F Monat als ganzes Wort, wie January oder March January bis December m Monat als Zahl, mit führenden Nullen 01 bis 12 M Monatsname mit drei Buchstaben Jan bis Dec n Monatszahl, ohne führende Nullen 1 bis 12 t Anzahl der Tage des angegebenen Monats 28 bis 31 Jahr --- --- L Schaltjahr oder nicht 1 für ein Schaltjahr, ansonsten 0 o Jahreszahl gemäß ISO-8601. Dies ergibt den gleichen Wert wie Y, außer wenn die ISO-Kalenderwoche (W) zum vorhergehenden oder nächsten Jahr gehört, wobei dann jenes Jahr verwendet wird (in PHP 5.1.0 hinzugefügt). Beispiele: 1999 oder 2003 Y Vierstellige Jahreszahl Beispiele: 1999 oder 2003 y Jahreszahl, zweistellig Beispiele: 99 oder 03 Uhrzeit --- --- a Kleingeschrieben: Ante meridiem (Vormittag) und Post meridiem (Nachmittag) am oder pm A Großgeschrieben: Ante meridiem (Vormittag) und Post meridiem (Nachmittag) AM oder PM B Swatch-Internet-Zeit 000 bis 999 g Stunde im 12-Stunden-Format, ohne führende Nullen 1 bis 12 G Stunde im 24-Stunden-Format, ohne führende Nullen 0 bis 23 h Stunde im 12-Stunden-Format, mit führenden Nullen 01 bis 12 H Stunde im 24-Stunden-Format, mit führenden Nullen 00 bis 23 i Minuten, mit führenden Nullen 00 bis 59 s Sekunden, mit führenden Nullen 00 bis 59 u Mikrosekunden (hinzugefügt in PHP 5.2.2) Beispiel: 654321 Zeitzone --- --- e Zeitzonen-Bezeichner (hinzugefügt in PHP 5.1.0) Beispiele: UTC, GMT, Atlantic/Azores I (großes 'i') Fällt ein Datum in die Sommerzeit 1 bei Sommerzeit, ansonsten 0. O Zeitunterschied zur Greenwich time (GMT) in Stunden Beispiel: +0200 P Zeitunterschied zur Greenwich time (GMT) in Stunden mit Doppelpunkt zwischen Stunden und Minuten (hinzugefügt in PHP 5.1.3) Beispiel: +02:00 T Abkürzung der Zeitzone Beispiele: EST, MDT ... Z Offset der Zeitzone in Sekunden. Der Offset für Zeitzonen westlich von UTC ist immer negativ und für Zeitzonen östlich von UTC immer positiv. -43200 bis 50400 Vollständige(s) Datum/Uhrzeit --- --- c ISO 8601 Datum (hinzugefügt in PHP 5) 2004-02-12T15:19:21+00:00 r Gemäß » RFC 2822 formatiertes Datum Beispiel: Thu, 21 Dec 2000 16:01:07 +0200 U Sekunden seit Beginn der UNIX-Epoche (January 1 1970 00:00:00 GMT) Siehe auch time() Nicht erkannte Zeichen werden unverändert ausgegeben. Das Z-Format gibt beim Gebrauch von gmdate() immer 0 zurück.
Hinweis:
Weil diese Funktion nur Integer-Zeitstempel akzeptiert, ist die Formatanweisung u nur nützlich, wenn man die Funktion date_format() mit von Benutzern angegebenen Timestamps aus der Funktion date_create() verwendet.
-
timestamp -
Der optionale Parameter
timestampist ein Unix Timestamp als integer oder die aktuelle lokale Zeit wenn keintimestampübergeben wurde. Er entspricht dann also dem Ergebnis der Funktion time().
Rückgabewerte
Gibt eine formatierte Datums-Zeichenkette zurück. Falls ein
nicht numerischer Wert als timestamp
übergeben wird, wird FALSE zurückgegeben und ein Fehler
der Stufe E_WARNING erzeugt.
Fehler/Exceptions
Jeder Aufruf der Datums- und Zeitfunktionen
generiert eine E_NOTICE-Warnung,
wenn die Zeitzone ungültig ist und eine E_STRICT-Nachricht
oder eine E_WARNING-Warnung,
wenn die Systemeinstellung oder die TZ-Umgebungsvariable
genutzt wird. Siehe auch date_default_timezone_set()
Changelog
| Version | Beschreibung |
|---|---|
| 5.1.0 | Der gültige Bereich eines Timestamp liegt typischerweise zwischen Fri, 13 Dec 1901 20:45:54 GMT und Tue, 19 Jan 2038 03:14:07 GMT. (Das entspricht den minimalen und maximalen Werten für einen vorzeichenbehafteten 32-Bit Integer). Vor PHP 5.1.0 war dieser Bereich auf manchen Systemen (z.B. Windows) eingeschränkt auf 01.01.1971 bis 19.01.2038. |
| 5.1.0 |
Erzeugt nun |
| 5.1.1 |
Es gibt nützliche Konstanten
von üblichen Datums-/Zeitformaten, die als
Format-Parameter übergeben werden können.
|
Beispiele
Beispiel #1 date()-Beispiele
<?php
// Die Standard-Zeitzone, die verwendet werden soll, setzen.
// Verfügbar seit PHP 5.1
date_default_timezone_set('UTC');
// Gibt etwas aus wie: 'Monday'
echo date("l");
// Gibt etwas aus wie: 'Monday 8th of August 2005 03:12:46 PM'
echo date('l jS \of F Y h:i:s A');
// Gibt aus: 'July 1, 2000 ist ein Saturday'
echo "July 1, 2000 ist ein " . date("l", mktime(0, 0, 0, 7, 1, 2000));
/* Verwende die Konstanten im Format-Parameter */
// Gibt etwas aus wie 'Mon, 15 Aug 2005 15:12:46 UTC'
echo date(DATE_RFC822);
// Gibt etwas aus wie '2000-07-01T00:00:00+00:00'
echo date(DATE_ATOM, mktime(0, 0, 0, 7, 1, 2000));
?>
Möchten Sie verhindern, dass ein erkanntes Zeichen im Formatstring ersetzt wird, sollten Sie dieses Zeichen mit einem vorangestellten Backslash escapen. Ist das Zeichen mit dem Backslash bereits eine spezielle Zeichenfolge, müssen Sie diesen Backslash ebenso escapen.
Beispiel #2 Escaping von Zeichen in date()
<?php
// Gibt etwas ähnliches aus wie 'Wednesday the 15th'
echo date('l \t\h\e jS');
?>
Es ist möglich, date() und mktime() gleichzeitig zu verwenden, um Datumsangaben in der Zukunft oder Vergangenheit zu bestimmen.
Beispiel #3 date() und mktime()-Beispiele
<?php
$morgen = mktime(0, 0, 0, date("m") , date("d")+1, date("Y"));
$letztermonat = mktime(0, 0, 0, date("m")-1, date("d"), date("Y"));
$naechstesjahr = mktime(0, 0, 0, date("m"), date("d"), date("Y")+1);
?>
Hinweis:
Dieses Vorgehen kann zu verlässlicheren Ergebnissen führen, als simples addieren oder subtrahieren der Anzahl von Sekunden in Tagen oder Monaten zu einem Timestamp, da Sommer- und Winterzeit berücksichtigt werden.
Es folgen einige Beispiele zur date()-Formatierung. Beachten Sie, dass Sie alle anderen Zeichen escapen sollten, da alle Zeichen, die im Augenblick eine spezielle Bedeutung haben, unerwünschte Resultate liefern. Bei allen weiteren Zeichen kann es durchaus möglich sein, dass diesen in zukünftigen PHP-Versionen eine Bedeutung zukommt. Beim Escapen sollten Sie darauf achten, einfache Anführungszeichen zu benutzen, damit Zeichenfolgen wie zum Beispiel \n zu keinem Zeilenumbruch führen.
Beispiel #4 date()-Formatierungen
<?php
// ANgenommen, heute ist der 10. März 2001, 17:16:18 Uhr und wir
// befinden uns in der Zeitzone Mountain Standard Time (MST)
$heute = date("F j, Y, g:i a"); // March 10, 2001, 5:16 pm
$heute = date("m.d.y"); // 03.10.01
$heute = date("j, n, Y"); // 10, 3, 2001
$heute = date("Ymd"); // 20010310
$heute = date('h-i-s, j-m-y, it is w Day'); // 05-16-18, 10-03-01, 1631 1618 6 Satpm01
$heute = date('\i\t \i\s \t\h\e jS \d\a\y.'); // it is the 10th day.
$heute = date("D M j G:i:s T Y"); // Sat Mar 10 17:16:18 MST 2001
$heute = date('H:m:s \m \i\s\ \m\o\n\t\h'); // 17:03:18 m is month
$heute = date("H:i:s"); // 17:16:18
?>
Um Datumsangaben in anderen Sprachen auszugeben, sollten Sie die Funktionen setlocale() und strftime() statt date() verwendet werden.
Anmerkungen
Hinweis:
Um einen Zeitstempel aus einer Textrepräsentation eines Datums zu erzeugen, kann die Funktion strtotime() verwendet werden. Einige Datenbanken haben außerdem Funktionen, mit denen ihre Datumsformate in Zeitstempel konvertiert werden können (wie z.B. die Funktion » UNIX_TIMESTAMP von MySQL).
Tipp
Der Zeitstempel des Verarbeitungsbeginns der HTTP-Anfrage wird seit PHP 5.1 in $_SERVER['REQUEST_TIME'] bereitgestellt.
Siehe auch
- gmdate() - Formatiert eine GMT/UTC Zeit-/Datumsangabe
- idate() - Format a local time/date as integer
- getdate() - Gibt Datums- und Zeitinformationen zurück
- getlastmod() - Uhrzeit der letzten Änderung eines Scripts
- mktime() - Gibt den Unix-Timestamp/Zeitstempel für ein Datum zurück
- strftime() - Formatiert eine Zeit-/Datumsangabe nach den lokalen Einstellungen
- time() - Gibt den aktuellen Unix-Timestamp/Zeitstempel zurück
- strtotime() - Wandelt ein beliebiges in englischer Textform angegebenes Datum in einen UNIX-Zeitstempel (Timestamp) um
- Vordefinierte DateTime-Konstanten
add a note
User Contributed Notesdate
Eren - erenezgu at gmail.com
13-Jul-2007 09:18
13-Jul-2007 09:18
hunterd1972 at gmail dot com
06-Jul-2007 10:13
06-Jul-2007 10:13
concatenate the values of each select statement to form the date into a month day, year format (i.e. January 1, 2007) and then use the strtotime function.
<?php
$timestamp = strtotime($month . " " . $day . ", " . $year);
?>
pierrotevrard at gmail dot com
03-Jul-2007 01:11
03-Jul-2007 01: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>';
?>
tszming at gmail dot com
03-Jul-2007 06:34
03-Jul-2007 06:34
for performance wise, don't call too many date() unless you really need it
i.e.
don't:
$tomorrow = mktime(0, 0, 0, date("m") , date("d")+1, date("Y"));
but:
list($mon, $day, $year) = split("-", date("m-d-Y"));
$tomorrow = mktime(0, 0, 0, $mon , $day+1, $year);
jcwebb at dicoe dot com
19-Jun-2007 07:48
19-Jun-2007 07: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
14-Jun-2007 05:05
14-Jun-2007 05: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 03:55
12-Jun-2007 03: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
11-Jun-2007 05:55
11-Jun-2007 05: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
20-May-2007 09:30
20-May-2007 09: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");
?>
Josue Resende
10-May-2007 05:32
10-May-2007 05:32
...
class CalendarFunction {
function holidays($year) {
$return = array();
$return[ 1] = array(1);
$return[12] = array(25);
// feriados moveis
return $return;
}
function qtDaysPerMonth($year, $month) {
return intval(date('t', mktime(0, 0, 0, intval($month), 1, intval($year))));
}
function daysPerMonth($year) {
$return = array();
$weekday = date('w', mktime(0, 0, 0, 1, 1, intval($year)));
$holidays = CalendarFunction::holidays($year);
for ($month = 0; $month < 12; $month++) {
$qt = CalendarFunction::qtDaysPerMonth($year, $month+1);
$holidays_month = (isset($holidays[$month+1]) ? $holidays[$month+1] : array());
for($day = 1; $day <= $qt; $day++) {
if (($weekday > 0 and $weekday < 6) and !in_array($day, $holidays_month)) {
$return[$month+1][] = $day;
}
$weekday = ($weekday == 6 ? 0 : $weekday + 1);
}
}
return $return;
}
}
...
fokeyjoe at themotto dot co dot uk
03-May-2007 06:52
03-May-2007 06: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.
bakadesu
02-May-2007 11:58
02-May-2007 11:58
In reply to josh's suggestion, you can achieve the same thing by doing:
<?php
$date = date($syntax, strtotime($datetime));
?>
jonbarnett at gmail dot com
24-Apr-2007 09:37
24-Apr-2007 09: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.
josh
23-Apr-2007 08:15
23-Apr-2007 08:15
Ever had a DATETIME in a database and want to format it using the date() function? Me too. Here you go.
<?
// format MySQL DateTime (YYYY-MM-DD hh:mm:ss) using date()
function datetime($syntax,$datetime) {
$year = substr($datetime,0,4);
$month = substr($datetime,5,2);
$day = substr($datetime,8,2);
$hour = substr($datetime,11,2);
$min = substr($datetime,14,2);
$sec = substr($datetime,17,2);
return date($syntax,mktime($hour,$min,$sec,$month,$day,$year));
}
?>
soreenpk at yahoo dot com
15-Mar-2007 07:03
15-Mar-2007 07:03
we can find the different in days between two date e.g now and some past date from db throught the following simple line of code;
$digest_date = "2007-03-15";
$date_diff = date("d",strtotime(date('y-m-d'))) - date("d",strtotime($digest_date));
dmitrid at dont_show dot com
10-Mar-2007 09:14
10-Mar-2007 09: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()
wips at mail dot ru
15-Feb-2007 04:04
15-Feb-2007 04:04
/**
* Defines week limits.
* Week numbers in [1..54]. First week is from 1st of Jan till first Sunday in year, last week is from last monday
* in year till 31st of Dec.
*
* @param int $weekNumber - Week number
* @param int $year - Year
* @return array - array($start_time, $end_time). $start_time - begin of week, $end_time - end of week in Unix timestamp.
* Precition is +-24 hours.
*/
function week_limits($weekNumber, $year)
{
// begin datetime
$time = mktime(1, 1, 1, 1, 1, $year);
// Aassuring that $weekNumber is number
$weekNumber--;
// If first week of year starts not from monday, date() will return "not correct" result (in this case first week is 0)
if (date('w', $time) == 1)
$weekNumber++;
$start_time = false;
$end_time = false;
for ($day = 1; $day <= 380; $day++)
{
if (date('W', $time) == $weekNumber && !$start_time)
$start_time = $time;
if (date('W', $time - 24*60*60) == $weekNumber && !$end_time && date('W', $time) != $weekNumber)
$end_time = $time - 24*60*60;
if ($start_time && $end_time)
break;
$time += 24*60*60;
}
return array($start_time, $end_time);
}//week_limits()
dragon at alimex dot biz
15-Feb-2007 09:30
15-Feb-2007 09:30
The function posted by mybenchmarkid down is great, but I would suggest a slight change.
The "$days" line should be without the "+1" at the end:
$days = (strtotime($endDate) - strtotime($startDate)) / 86400;
and the "for" line should be with "<=" instead of "<":
for($i=0; $i<=$days; $i++)
This way you can use a specific endDate or just use today:
$days = (time() - strtotime($startDate)) / 86400;
It will work both ways.
Bobby
mybenchmarkid at yahoo dot com
13-Feb-2007 07:55
13-Feb-2007 07:55
here is a function I wrote that was useful for a calendar application I was using.
It returns an array of the valid dates between two parameter dates. enjoy.
<?
function DatesBetween($startDate, $endDate){
// get the number of days between the two given dates.
$days = (strtotime($endDate) - strtotime($startDate)) / 86400 + 1;
$startMonth = date("m", strtotime($startDate));
$startDay = date("d", strtotime($startDate));
$startYear = date("Y", strtotime($startDate));
$dates;//the array of dates to be passed back
for($i=0; $i<$days; $i++){
$dates[$i] = date("n/j/Y", mktime(0, 0, 0, $startMonth , ($startDay+$i), $startYear));
}
return $dates;
}
?>
example: $dates = DatesBetween("2/27/2007","3/3/2007")
Array ( [0] => 2/27/2007 [1] => 2/28/2007 [2] => 3/1/2007 [3] => 3/2/2007 [4] => 3/3/2007 )
rodflash.com
08-Feb-2007 04:24
08-Feb-2007 04:24
To make date comparison, don't use date() function. Use strtotime
//Check earlier date
$date=strtotime("$month/$day/$year");
$today=strtotime("now");
if ($date> $today) {
//Early date
} else {
//Old date
}
You can also put another input formats:
http://www.gnu.org/software/tar/manual/html_node/tar_109.html
Eamon Straughn eamon at gizzle dot co dot uk
05-Feb-2007 10:33
05-Feb-2007 10:33
Check this out this is a class i made last year for Gizzle.co.uk but sinced used on other projects and is quite a treat. It checks for a absolute valid date or datetime type. returns booleen. Disclaimer I do not take responsibility for the use of this class. I guarantees it works.
<?php
#Created By Eamon Straughn, Class extends Date() informally
class isDate
{
private $arg;
private $return = false;
private $stack;
private $stacks;
private $pos = array();
private $poss = array();
public function __construct($arg)
{
$this->arg = trim($arg);
}
private function DateType()
{
//if length is more than 10 then it is not a date
if(($n = strlen($this->arg)) > 10)
return false;
//if length is less than 6 then it is not a date
elseif($n < 6)
return false;
//get values into arrays for processing
for($i = 0; $i < $n; $i ++)
{
if(is_numeric($this->arg[$i]))
$this->stack .= (isset($this->arg[$i])) ? $this->arg[$i] : null;
elseif(($this->arg[$i] == "-") || ($this->arg[$i] == "/") || ($this->arg[$i] == "\\"))
$this->pos[$i] = (isset($i)) ? $i : null;
}
//strip values to be checked
if(is_numeric($c = substr($this->stack, 0, current($this->pos))))
$d = (strlen($c) > 2) ? substr($this->stack, current($this->pos), current($this->pos)/2) : substr($this->stack, current($this->pos), current($this->pos));
else
return false;
if(is_numeric($d))
if(is_numeric($e = substr($this->stack, end($this->pos)-1, end($this->pos)-1)));
//convert string to integer
$c = (int) $c;
$d = (int) $d;
$e = (int) $e;
//check if it is a valid date
if((checkdate($d,$c,$e)) || (checkdate($d,$e,$c)))
return true;
return false;
}
private function DateTimeType()
{
//if length is more than 10 then it is not a datetime
if(($n = strlen($this->arg)) < 10)
return false;
//if length is less than 19 then it is not a datetime
elseif($n < 19)
return false;
//get values into arrays for processing
for($i = 0; $i < $n; $i ++)
{
if(is_numeric($this->arg[$i]))
$this->stacks .= (isset($this->arg[$i])) ? $this->arg[$i] : null;
elseif(($this->arg[$i] == "-") || ($this->arg[$i] == "/") || ($this->arg[$i] == "\\") || ($this->arg[$i] == " ") || ($this->arg[$i] == ":"))
$this->poss[$i] = (isset($i)) ? $i : null;
}
//strip values to be checked
if(is_numeric($c = substr($this->stacks, 0, current($this->poss))))
$d = (strlen($c) > 2) ? substr($this->stacks, current($this->poss), current($this->poss)/2) : substr($this->stacks, current($this->poss), current($this->poss));
else
return false;
if(is_numeric($d))
$e = (strlen($c) > 2) ? substr($this->stacks, next($this->poss)-1, (next($this->poss)-1)/4) : substr($this->stacks, next($this->poss)-1, (next($this->poss)-1)/2);
if(is_numeric($e))
if(is_numeric($f = substr($this->stacks, (next($this->poss)/2)+2, 2)));
if(is_numeric($g = substr($this->stacks, (next($this->poss)/2)+2, 2)));
if(is_numeric($h = substr($this->stacks, (end($this->poss)/2)+4, 2)));
//convert string to integer
$c = (int) $c;
$d = (int) $d;
$e = (int) $e;
$f = (int) $f;
$g = (int) $g;
$h = (int) $h;
//check if the time is valid
if($f > 24)
return false;
if($g > 60)
return false;
if($h > 60)
return false;
//check if it is a valid date
if((checkdate($d,$c,$e)) || (checkdate($d,$e,$c)))
return true;
return false;
}
public function DateCheck()
{
if($this->DateTimeType())
$this->return = true;
elseif($this->DateType())
$this->return = true;
else
$this->return = false;
return $this->return;
}
}
?>
example of use
<?php
//assign a date
$d = "2006-12-12 10:15:00"; $t = "12-12-2006"; $f = "1-1-2001 10:23:09";
//the above can be used regardless if it is shortdate or long date but remember the year must always be 4 integers.
$c = new isDate($d);
if($c->CheckDate() !== false) echo $d;
?>
if anyone wants to extend it to check time and posibly do more feel free to.
Eamon..
cj at 407x dot com
05-Feb-2007 08:43
05-Feb-2007 08:43
This is a very simple few lines of code to display dates that arrive in various formats:
$dateArray=explode('-','2007-02-05');
// $dateArray[0]= 2007
// $dateArray[1] = 02
// $dateArray[2] = 05
echo date('M j, Y', mktime(0, 0, 0, $dateArray[1], $dateArray[2], $dateArray[0]));
// result: Feb 2, 2007
alter your explode characters and dateArray positions to suit.
Chris
marius at svr dot ro
05-Feb-2007 07:54
05-Feb-2007 07: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
?>
mtphotographer at yahoo dot com
30-Jan-2007 04:37
30-Jan-2007 04:37
Determine what is next month:
I Had the same issue as matt_wbdi at hotmail dot com
Simple solution is use 1 for the day instead of date("d"), it didnt seem to matter if I use "m", or "n" for the month.
// eg:
// if today is 2007-01-30 the following:
$datePlusoneMonth = mktime(0, 0, 0, date("m")+ 1, date("d"), date("Y"));
echo date("Y-m", $datePlusoneMonth);
//returns 2007-03 which is not next month
// this worked for me:
$datePlusoneMonth = mktime(0, 0, 0, date("m")+ 1, 1, date("Y"));
echo date("Y-m", $datePlusoneMonth);
// returns 2007-02, which IS next month
matt_wbdi at hotmail dot com
30-Jan-2007 10:06
30-Jan-2007 10:06
The below code doesn't work. The $next_month variable, for instance, right now, will be March, even though today is January 30th. The reason is because one month from Jan. 30th is March. But that's not the next month. I would suggest using an array of Month names instead, with their respective number as the key.
kriswarner at solidaritymail dot com
24-Jan-2007 06:40
24-Jan-2007 06:40
Here's a useful bit of code - I took Mushy's code for
displaying a calendar, and added links for viewing previous
and next months, so you can go ahead or backwards as many months as you like, one month at a time.
Basically the top row is changed, and looks like:
December (prev) January February (next)
Here it is:
<?
//determining action, current month and year
$action = $_REQUEST['action'];
if (!$action) //first page, set current_month variable = current month
{
$current_month = date("m"); //value will change if the user changes the month they are viewing
$current_year = date('Y');
}
else //if user selected to go to previous or next month, reset current_month variable
{
$current_month = $_REQUEST['current_month'];
$current_year = $_REQUEST['current_year'];
if ($action == 'prev')
{
$current_month = date('m', mktime(0, 0, 0, $current_month-1));
//if going from january to december, change year as well
if ($current_month == '12')
{
$current_year = date('Y', mktime(0, 0, 0, $current_month, 1, $current_year-1));
}
}
if ($action == 'next')
{
$current_month = date('m', mktime(0, 0, 0, $current_month+1));
//if going from december to january, change year as well
if ($current_month == '01')
{
$current_year = date('Y', mktime(0, 0, 0, $current_month, 1, $current_year+1));
}
}
}
$previous_month = date('F', mktime(0, 0, 0, $current_month-1, date("d"), date("Y")));
$next_month = date('F', mktime(0, 0, 0, $current_month+1, date("d"), date("Y")));
$theday = date(w, mktime(0, 0, 0, $current_month, 1, $current_year));
$daysinmonth = date("t", mktime(0, 0, 0, $current_month, 1, $current_year));
echo "<table border=1 width=90%>";
echo "<tr><td><a href=$PHP_SELF?action=prev¤t_month=".$current_month."
¤t_year=".$current_year.">$previous_month</a></td>
<td colspan=5 align=center>".date('F Y', mktime(0, 0, 0, $current_month, 1, $current_year))."</td>
<td><a href=$PHP_SELF?action=next¤t_month=".$current_month."
¤t_year=".$current_year.">$next_month</a></td></tr>";
echo "<tr>";
echo "<td>Sunday</td>";
echo "<td>Monday</td>";
echo "<td>Tuesday</td>";
echo "<td>Wednesday</td>";
echo "<td>Thursday</td>";
echo "<td>Friday</td>";
echo "<td>Saturday</td>";
echo "</tr>";
echo "<tr>";
for ($i=0;$i<$theday;$i++)
{
echo "<td> </td>";
}
for ($list_day=1;$list_day<=$daysinmonth;$list_day++)
{
echo "<td>" . $list_day . "</td>";
if ($theday == 6)
{
echo "</tr>";
echo "<tr>";
$theday = -1;
}
$theday++;
}
echo "</tr>";
echo "</table>";
?>
code at ashleyhunt dot co dot uk
17-Jan-2007 10:22
17-Jan-2007 10:22
I wanted to shift an sql date forward by a set time period.
This is how I achived it... well handy.
<?
function sql_date_shift($date, $shift)
{
return date("Y-m-d H:i:s" , strtotime($shift, strtotime($date)));
}
// example usage
$date = "2006-12-31 21:00";
$shift "+6 hours"; // could be days, weeks... see function strtotime() for usage
echo sql_date_shift($date, $shift);
// will output: 2007-01-01 03:00:00
?>
Hope it is of use,
Ashley
wcc at techmonkeys dot org
22-Dec-2006 08:22
22-Dec-2006 08:22
In example 3, <?php date("m") ?> is passed to mktime() for the month argument. I believe <?php date("n") ?> should be used instead so that the leading 0's don't make PHP think the arguments are octal values. The same goes for <?php date("j") ?> instead off <?php date("d") ?>.
<?php
echo mktime(0, 0, 0, 09, 09, 2006);
echo "\n";
echo mktime(0, 0, 0, 9, 9, 2006);
?>
1133326800
1157774400
s.koch AT brindestorm.com
20-Dec-2006 11:51
20-Dec-2006 11:51
mysql date format:
<?
$mysq_format_date = date("Y-m-d H:i:s");
?>
28-Nov-2006 08:26
if you are sending your data to a database, you can just send time() and then use strftime() to turn the time() string into readable time format.
check both time() and strftime() functions both offer more or less same functionality as date(). date() can also be used with time() strings to display time in the past.
more or less with something like:
date("j F, Y - g:ia", $data['date_quoted'])
where time() = $data['date_quoted'] and time() is the exact time date when the string is executed. if this is done towards a database, the time() stored is the actual server time upon script execution, no matter the time set in the individual computer, this will record server time, unless a gmt is set in newer versions of php (5 and up).
jack at jtr dot de
26-Nov-2006 10:30
26-Nov-2006 10:30
/**
* Converts a date 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 "<br>";
print_r( $date_str_parts ); echo "<br>";
$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;
}
$dummy_ts = mktime( 0,0,0, $date_elements['m'],$date_elements['d'],$date_elements['Y']);
return date( $date_format2, $dummy_ts );
}
$df_src = 'd/m/Y';
$df_des = 'Y-m-d';
$iso_date = dates_interconv( $df_src, $df_des, '25/12/2005');
output:
2005-12-25
Batman
16-Nov-2006 05:56
16-Nov-2006 05:56
date("W") will not take into account US-system of weeks (it starts on Sunday).
Example:
According to ISO 8601, 1 Jan 2006 is on Sunday therefore in US-system 1 -- 7 January will be 52 week and not 1st!
But date() will print 1 and not 52.
Bandit
07-Nov-2006 02:06
07-Nov-2006 02:06
So I wanted a little function to output an easy to read but inaccurate date. I came up with the following (probably very inefficient) little function;
<?php
function ezDate($d) {
$ts = time() - strtotime(str_replace("-","/",$d));
if($ts>31536000) $val = round($ts/31536000,0).' year';
else if($ts>2419200) $val = round($ts/2419200,0).' month';
else if($ts>604800) $val = round($ts/604800,0).' week';
else if($ts>86400) $val = round($ts/86400,0).' day';
else if($ts>3600) $val = round($ts/3600,0).' hour';
else if($ts>60) $val = round($ts/60,0).' minute';
else $val = $ts.' second';
if($val>1) $val .= 's';
return $val;
}
?>
Then I use it as follows;
<?php
echo ucwords(ezDate('2006-09-07 18:42:00')).' Ago';
?>
Which would output;
2 Months Ago
I add an acronym tag around the output also, so my users can mouse-over for the exact date.
Hope it helps someone!
Lionel
26-Oct-2006 10:38
26-Oct-2006 10:38
my quick and dirty code to find the season of the current date
<?php
function season() {
$limits=array('/12/21'=>'Winter', '/09/21'=>'Autumn', '/06/21'=>'Summer', '/03/21'=>'Spring', '/01/01'=>'Winter');
foreach ($limits AS $key => $value) {
$limit=date("Y").$key;
if (strtotime($adate)>=strtotime($limit)) {
return $value;
}
}
}
echo season();
?>
PS: the 21th is a good approach but not the real day.
lcapt at dplanet dot ch
26-Oct-2006 09:44
26-Oct-2006 09:44
my quick and dirty code to find the season of the date
<?php
function season() {
$limits=array('/12/21'=>'Winter','/09/21'=>'Autumn',
'/06/21'=>'Summer','/03/21'=>'Spring','/12/31'=>'Winter');
foreach ($limits AS $key => $value) {
$limit=date("Y").$key;
if (strtotime("now")>strtotime($limit)) {
return $value;
}
}
}
echo season();
?>
PS: the 21th is a good approach but not the real day.
admin [at] xorath [dot] com
23-Oct-2006 05:13
23-Oct-2006 05:13
If you want to use the date function to fix the RFC-822 format from an allready made RSS 2.0 feed you can do it like this..
Maybe getting an external feed from another asp or php file that you cannot change, but want to have the correct dateformat for anyway.
<?php
header('Content-type: application/rss+xml; charset=iso-8859-1');
$xmlfile = simplexml_load_file($_GET[feedURL]);
for ( $i = 0; $i < count($xmlfile->channel->item); $i++ )
$xmlfile->channel->item[$i]->pubDate = date("r",strtotime((string)($xmlfile->channel->item[$i]->pubDate)));
echo $xmlfile->asXML();
?>
Then simply link to your rss feed like this
filename.php?feedURL=http://www.example.com/rss.asp
filename.php?feedURL=http://www.example.com/rss.xml
filename.php?feedURL=http://www.example.com/rss.php
or what you want. Hope anyone can take advantage of this, I wrote it to help a friend which had date stored in database only by yyyy-mm-dd hh:mm:ss and retrieved via asp from another script.
Article at http://www.xorath.com/articles/?article=2
emailfire at gmail dot com
07-Oct-2006 06:39
07-Oct-2006 06:39
To use the date("N") function in PHP < 5.1.0 use:
<?php
function dayofweek() {
$days = array("Mon", "Tue", "Wed", "Thu", "Fri", "Sat", "Sun");
return array_search(date("D"), $days) + 1;
}
?>
Mushy
30-Sep-2006 04:17
30-Sep-2006 04:17
Heres a basic print out of a calender:
<?
$date_month = 7;
$date_year = 2006;
$theday = date(w, mktime(0, 0, 0, $date_month, 1, $date_year));
$daysinmonth = date("t", mktime(0, 0, 0, $date_month, 1, $date_year));
echo "<table border=1>";
echo "<tr>";
echo "<td>Sunday</td>";
echo "<td>Monday</td>";
echo "<td>Tuesday</td>";
echo "<td>Wednesday</td>";
echo "<td>Thursday</td>";
echo "<td>Friday</td>";
echo "<td>Saturday</td>";
echo "</tr>";
echo "<tr>";
for ($i=0;$i<$theday;$i++)
{
echo "<td> </td>";
}
for ($list_day=1;$list_day<=$daysinmonth;$list_day++)
{
echo "<td>" . $list_day . "</td>";
if ($theday == 6)
{
echo "</tr>";
echo "<tr>";
$theday = -1;
}
$theday++;
}
echo "</tr>";
echo "</table>";
?>
Michiel
28-Sep-2006 05:08
28-Sep-2006 05:08
If you want to count quarters between dates you can use the following:
function countQuarters($begindate, $enddate)
{
if (!isset($begindate) || empty($begindate) || !isset($enddate) || empty($enddate))
return -1;
$countyears = date("Y", strtotime($enddate)) - date("Y", strtotime($begindate));
$quarters = 0;
if (date("Y", strtotime($enddate)) == date("Y", strtotime($begindate)))
{
if (date("m", strtotime($enddate)) != date("m", strtotime($begindate)))
{
if (date("m", strtotime($enddate)) > date("m", strtotime($begindate)))
{
$difference = date("m", strtotime($enddate)) - date("m", strtotime($begindate));
$quarters += ceil((int) $difference / 4);
}
else
{
return -1;
}
}
}
else
{
$quarters = (int) $countyears * 4;
if (date("m", strtotime($enddate)) != date("m", strtotime($begindate)))
{
if (date("m", strtotime($enddate)) > date("m", strtotime($begindate)))
{
$difference = date("m", strtotime($enddate)) - date("m", strtotime($begindate));
$quarters += ceil((int) $difference / 4);
}
else
{
$afterbegin = 12 - (int) date("m", strtotime($begindate));
$untilend = date("m", strtotime($enddate));
$quarters = ($quarters - 4) + ceil(($afterbegin + $untilend) / 4);
}
}
}
return $quarters;
}
mandi tek shqiperia.com
15-Sep-2006 04:15
15-Sep-2006 04:15
If you have a date in the english format"Thu Sep 07 23:59:35 CEST 2006" (some times generated from logs or other systems) and you need to translate it in mm/dd/yyyy you can use the following function!
//$data="Thu Sep 07 23:59:35 CEST 2006";
function formadatedb($data)
{
$dt=explode(" ", $data);
$year=array ("Jan"=>1, "Feb"=>2, "Mar"=>3, "Apr"=>4, "May"=>5, "Jun"=>6, "Jul"=>7, "Aug"=>8, "Sep"=>9,"Oct"=>10,"Nov"=>11,"Dec"=>12);
return $year[$dt[1]]."/".$dt[2]."/".$dt[5];
}
russ at isitaboat dot co dot uk
06-Sep-2006 04:18
06-Sep-2006 04:18
Easy way of switching between mysql and "normal" dates (english, not american)...
<?php
function flipdate($dt, $seperator_in = '-', $seperator_out = '-')
{
return implode($seperator_out, array_reverse(explode($seperator_in, $dt)));
}
?>
michiel at mb-it dot nl
04-Sep-2006 02:59
04-Sep-2006 02:59
***EDITOR NOTE: Referred to note has been removed.
The calculation function of the number of days between 2 dates by zzzdobr at gmai dot com could be done much easier:
<?
function getdays($day1,$day2)
{
return round((strtotime($day2)-strtotime($day1))/(24*60*60),0);
}
$begin = date("Y/m/d"); // we set today as an example
$end = "2006/11/27";
getdays($begin,$end);
?>
So now all of you know how many days you have left to buy me a birthday present ;)
James
29-Aug-2006 02:45
29-Aug-2006 02:45
Slightly modified the code provided by "martin at smttuk dot com" so that you can give the function a date and/or time that you choose;
<?php
function zonedate($layout, $countryzone, $daylightsaving, $time)
{
if($daylightsaving) {
$daylight_saving = date('I');
if($daylight_saving){ $zone=3600*($countryzone+1); }
}
else {
if( $countryzone>>0){ $zone=3600*$countryzone; }
else { $zone=0; }
}
if(!$time) { $time = time(); }
$date = gmdate($layout, $time + $zone);
return $date;
}
?>
For example if I wanted the time and date of my birthday in New Zealand time;
<?php
echo zonedate('Y-m-d H:i:s',-12,true,mktime(18,46,0,9,7,1986));
?>
Corey
28-Aug-2006 02:55
28-Aug-2006 02:55
It's pretty simple, but in case anybody else is having problems getting the exact time they need because of DST (ex: on a Windows box in an area without DST), you can fix it all in a single line. Example...
<?php
echo "The time is " . date((date("I") ? intval(date("g")) - 1 : date("g")) . ":i m/d/y") . ".";
?>
martin at smttuk dot com
25-Aug-2006 01:30
25-Aug-2006 01:30
/* Country Zone : Time Zone Name
-12 : Dateline Standard
-11 : Samoa Standard Time
-10 : Hawaiian Standard Time
-8 : Pacific Standard Time
-7 : Mexican Standard Time, Mountain Standard Time
-6 : Central Standard Time, Mexico Standard Time
-5 : Eastern Standard Time Eastern Time, SA Pacific Standard Time
-4 : Atlantic Standard Time, SA Western Standard Time, Pacific SA Standard Time
-3.5 : Newfoundland Standard Time
-3 : SA Eastern Standard Time, E. South America Standard Time
-2 : Mid:Atlantic Standard Time
-1 : Azores Standard Time, Cape Verde Standard Time
0 : Universal Coordinated Time, Greenwich Mean Time
1 : Romance Standard Time, Central Africa Standard Time, Central European Standard Time
2 : Egypt Standard Time, South Africa Standard Time, E. Europe Standard Time, FLE Standard Time, GTB Standard Time
3 : Arab Standard Time, E. Africa Standard Time, Arabic Standard Time, Russian Standard Time
3.5 : Iran Standard Time
4 : Arabian Standard Time, Caucasus Standard Time, Afghanistan Standard Time
5 : West Asia Standard Time
5.5 : India Standard Time
5.75 : Nepal Standard Time
6 : Central Asia Standard Time
6.5 : Myanmar Standard Time
7 : SE Asia Standard Time, North Asia Standard Time
8 : China Standard Time, W. Australia Standard Time, Singapore Standard Time, Taipei Standard Time, North Asia East Standard Time
9 : Tokyo Standard Time, Korea Standard Time, Yakutsk Standard Time
9.5 : AUS Central Standard Time, Cen. Australia Standard Time
10 : AUS Eastern Standard Time, E. Australia Standard Time
West Pacific Standard Time, Tasmania Standard Time, Vladivostok Standard Time
11 : Central Pacific Standard Time
12 : Fiji Standard Time, New Zealand Standard Time
13 : Tonga Standard Time
* How to use
$layout =
Same function as date : http://uk2.php.net/manual/en/function.date.php
$countryzone =
Country Zone from Above Eg: 0 ,for Greenwich Mean Time
$daylightsaving =
Set true if the Country has daylight saving it will auto change.
Set false if the Country dose not have daylight saving or wish to it Disabled.
(About Daylight Saving go here : http://www.timeanddate.com/time/aboutdst.html)
Call Function:
zonedate($layout, $countryzone, $daylightsaving);
E.g.
If GMT = Friday 25th of August 2006 10:23:17 AM
When Function called:
// West Asia Standard Time (Country Uses daylight saving)
echo zonedate("l dS \of F Y h:i:s A", 5, true);
//Output : Friday 25th of August 2006 03:23:17 PM
*/
function zonedate($layout, $countryzone, $daylightsaving)
{
if ($daylightsaving){
$daylight_saving = date('I');
if ($daylight_saving){$zone=3600*($countryzone+1);}
}
else {
if ($countryzone>>0){$zone=3600*$countryzone;}
else {$zone=0;}
}
$date=gmdate($layout, time() + $zone);
return $date;
}
Ron
09-Aug-2006 07:34
09-Aug-2006 07:34
Example 3 is really very bad programming practice. Calling date() more than once and putting the results together, can cause you to have a date or time that is inconsistent, or just plain invalid, because the system clock could easily change between the calls.
Instead, call time() once up front to get the timestamp, then pass that into each call to date() like this:
<?php
$now = time();
$tomorrow = mktime(0, 0, 0, date("m", $now) , date("d", $now)+1, date("Y", $now));
$lastmonth = mktime(0, 0, 0, date("m", $now)-1, date("d", $now), date("Y", $now));
$nextyear = mktime(0, 0, 0, date("m", $now), date("d", $now), date("Y", $now)+1);
?>
By doing this, we ensure that we're using the same system clock sampling for all date/time field formatting, thereby ensuring the results are consistent.
mwwaygoo AT hotmail DOT com
09-Aug-2006 05:11
09-Aug-2006 05:11
Number of weeks per month
I was trying to do a monthly calendar and required the number of weeks in a month, running from Monday to Sunday. Since PHP doesn't have this in its date() parameters I had to calculate it in a roundabout manner. By subtracting the week numbers away from each other we SHOULD get the number of weeks, since it is calculated on Mondays.
<?php
$year = date("Y", $date);
$month = date("m", $date);
if( (isset($_GET['year'])) && (intval($_GET['year']) > 1582) )
{
$year = intval($_GET['year']);
}
if( (isset($_GET['month'])) && (intval($_GET['month']) >= 1) && (intval($_GET['month']) <= 12) )
{
$month = intval($_GET['month']);
}
$date = mktime(1, 1, 1, $month, date("d"), $year);
$first_day_of_month = strtotime("-" . (date("d", $date)-1) . " days", $date);
$last_day_of_month = strtotime("+" . (date("t", $first_day_of_month)-1) . " days", $first_day_of_month);
$first_week_no = date("W", $first_day_of_month);
$last_week_no = date("W", $last_day_of_month);
if($last_week_no < $first_week_no) $last_week_no=date("W", strtotime("-1 week",$last_week_no)) + 1;
$weeks_of_month = $last_week_no - $first_week_no + 1;
?>
The check for weeknumber of the end of the month being smaller than the beginning of the month, is because of December. Where Monday 31st is actually in the first week of the following year.
The +1 adjustment is for the number of weeks, inclusive. ie if January had five week, then 5-1=4, so we need to add an extra one to make it 5.
Phil Sylvia
08-Aug-2006 06:05
08-Aug-2006 06:05
I simplified this after I figured it out based upon Mel Boyce's simple solution. Thanks Mel!
I wanted to calculate dates based upon any given date and not just todays date which is what the hundreds of examples on the Internet use. I created a simple function and then just call the function with 2 parameters.. the date (string) to test and the number of days that I want to add (positive #) or subtract (negative #) My intended use is to retrieve dates from the database and perform the date calculations. This makes it simple. I hope this helps someone as frustrated as I was. Enjoy.
******************************************
<?php
// date calculation function
// adds or subtracts a date based upon the input.
// $this_date is a string format of a valid date ie.. "2006/08/11"
// $num_days is the number of days that you would like to add (positive number) or subtract (negative number)
function fnc_date_calc($this_date,$num_days){
$my_time = strtotime ($this_date); //converts date string to UNIX timestamp
$timestamp = $my_time + ($num_days * 86400); //calculates # of days passed ($num_days) * # seconds in a day (86400)
$return_date = date("Y/m/d",$timestamp); //puts the UNIX timestamp back into string format
return $return_date;//exit function and return string
}//end of function
$date_to_test = "2006/08/11";
$days_to_add = 7;
$past_date = fnc_date_calc($date_to_test,(($days_to_add)*-1));
$future_date = fnc_date_calc($date_to_test,$days_to_add);
echo "Test Date is: ".$date_to_test;
echo "<br>";
echo "Number of days to Calculate is: ".$days_to_add;
echo "<br>";
echo "Past date is: ".$past_date;
echo "<br>";
echo "Future date is: ".$future_date;
?>
Matt_B at TinyOnline dot co dot uk
04-Aug-2006 05:00
04-Aug-2006 05:00
In response to the getLastWeekDay() function:
***^ EDITOR NOTE: Referred to note was removed 2006-09-07.
Changing dates for any reason by adding/subtracting secret is a really bad idea. Daylight savings will totally screw up the calculations. Your best bets are the awesome strtotime features. To get last monday for example:
$var = strtotime('last monday');
Strtotime can do all sorts of funky stuff like this.
sea at zzti dot edu dot cn
03-Aug-2006 11:03
03-Aug-2006 11:03
in PHP and MySQL,the day of year is different:
<?php
echo date('z',strtotime('2006-01-01')); // print: 0
?>
mysql > SELECT DAYOFYEAR('2006-01-01'); // print: 1
27-Jul-2006 11:03
For PHP 4 users wanting a format similar to ISO 8601 (http://www.w3.org/TR/NOTE-datetime):
echo date('Y-m-d H:i:s.0T');
returns something like 2006-07-27 16:54:14.0EDT
rev at NOSPAMO dot returntothepit dot com
27-Jul-2006 08:48
27-Jul-2006 08:48
the CORRECT MySQl datetime format is
<?php
$date = "Last Saturday";
date("Y-m-d H:i:s",strtotime($date));
$sql = "INSERT INTO pictureusageindex (`subject`,`date`) VALUES ('$subject','$date')";
echo "$sql<br>";
?>
a person who posted above is wrong. leaving out the "-"
Bartlomiej B dot (berdzii at o2 dot pl)
25-Jul-2006 02:41
25-Jul-2006 02:41
To calculate current quarter of the year we can use this simple function:
function quarter()
{
return ceil(date("m")/3);
}
Alvin Delagon
20-Jul-2006 11:48
20-Jul-2006 11:48
Here's a function that takes the year as input and returns an array or dates that are mondays. (It can be used for generating weekly reports just like I did)
function getMondays($year) {
$newyear = $year;
$week = 0;
$day = 0;
$mo = 1;
$mondays = array();
$i = 1;
while ($week != 1) {
$day++;
$week = date("w", mktime(0, 0, 0, $mo,$day, $year));
}
array_push($mondays,date("r", mktime(0, 0, 0, $mo,$day, $year)));
while ($newyear == $year) {
$test = strtotime(date("r", mktime(0, 0, 0, $mo,$day, $year)) . "+" . $i . " week");
$i++;
if ($year == date("Y",$test)) {
array_push($mondays,date("r", $test));
}
$newyear = date("Y",$test);
}
return $mondays;
}
dulare at gmail dot com
13-Jul-2006 05:36
13-Jul-2006 05:36
If You are looking for some simple date calculations:
<?
function days_between($fyear, $fmonth, $fday, $tyear, $tmonth, $tday)
{
return abs((mktime ( 0, 0, 0, $fmonth, $fday, $fyear) - mktime ( 0, 0, 0, $tmonth, $tday, $tyear))/(60*60*24));
}
function day_before($fyear, $fmonth, $fday)
{
return date ("Y-m-d", mktime (0,0,0,$fmonth,$fday-1,$fyear));
}
function next_day($fyear, $fmonth, $fday)
{
return date ("Y-m-d", mktime (0,0,0,$fmonth,$fday+1,$fyear));
}
function weekday($fyear, $fmonth, $fday) //0 is monday
{
return (((mktime ( 0, 0, 0, $fmonth, $fday, $fyear) - mktime ( 0, 0, 0, 7, 17, 2006))/(60*60*24))+700000) % 7;
}
function prior_monday($fyear, $fmonth, $fday)
{
return date ("Y-m-d", mktime (0,0,0,$fmonth,$fday-weekday($fyear, $fmonth, $fday),$fyear));
}
?>
Elena S.
05-May-2006 11:36
05-May-2006 11:36
If you do not PHP5 yet but want a week day to be in ISO format: 1 (for Monday) through 7 (for Sunday), you can use this:
<?
//GET WEEK DAY 0 FOR SUNDAY, 6 FOR SATURDAY
$x = date( "w" );
$corrected_week_day = 7 - ( (7-$x) % (7+$x) );
?>
mel dot boyce at gmail dot com
06-Apr-2006 01:46
06-Apr-2006 01:46
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.
SpikeDaCruz
09-Mar-2006 08:12
09-Mar-2006 08:12
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.
<?
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");
}
?>
erwinmoller at xs4all dot nl
05-Jan-2006 01:34
05-Jan-2006 01:34
If you need dates that are prior to 1970 (or 1901 for php5.1), have a look at calendar at this very site:
http://www.php.net/calendar
martin dot m at hid dot gr
19-Dec-2005 05:25
19-Dec-2005 05:25
"It worked ok, except I noticed it had some trouble if you were spanning months, (i.e. 03-29-2005 to 04-10-2005)"
this is the (Daylight Saving Time ) problem. you can check if the start date and the end date are
whether or not in daylights savings time by using
date('I',$your_date) and to add or decrease with one hour.
Nick H
24-Nov-2005 03:21
24-Nov-2005 03:21
Users in GMT may find some information on British Summer Time useful. Personally I was confused that date() for a timestamp of 0 was returning 1am, until I found about the all-year BST from 1968-71.
http://wwp.greenwichmeantime.com/info/bst2.htm
itsacon at itsacon dot net
16-Nov-2005 11:28
16-Nov-2005 11:28
Caveat when using the 'W' and 'w' options together:
The 'W' option uses the ISO-8601 standard (week ends on sunday), whereas the 'w' option has the week _start_ on sunday (sunday == 0).
vernon at vernonkesner dot com
02-Nov-2005 06:37
02-Nov-2005 06:37
The examples for getting a date in the past or future is simply not the best way to do it. Especially if you are doing it dynamically.
I find the best way to get a date in the past or future is like this:
<?php
//get timestamp for past/future date I want
$pf_time = strtotime("-3 days");
//format the date using the timestamp generated
$pf_date = date("Y-m-d", $pf_time);
?>
martin at kurahaupo dot gen dot nz
30-Oct-2005 10:52
30-Oct-2005 10:52
There is a mistaken impression that the maximum difference between UTC and localtime is +/- 12 hours. Right now it is summer here in New Zealand, and we're 13 hours ahead of UTC, and further east in the Chatham Islands it's UTC+13:45.
Consequently, the range for the "Z" conversion is at least -43200 ... +49500
mbirth at webwriters dot de
25-Oct-2005 12:24
25-Oct-2005 12:24
Using 'B' for the Swatch Internet Time (i.Beats) can still lead to misunderstandings, because the date given in the resulting string is the local date, not the date of the BMT (Biel Mean Time / UTC+0100) after which the i.Beats are counted. So while @000 is equal all around the globe, October 25th 2005 @000 in Chicago is really October 24th, 06:00 PM local time.
Otherwise, if you use date('d M Y @B') in Chicago on that day at 6pm, it will return "24 Oct 2005 @000" although it should be "25 Oct 2005 @000".
So it may happen that you miss an appointment by 24 hours (or 1000 Beats ;-)
Here's a way to return the Internet Time with correct date:
<?php
$curtime = time();
$utcdiff = date('Z', $curtime); // get difference to UTC in seconds
$bmttime = $curtime - $utcdiff + 3600; // BMT = UTC+0100
$ssm = date('H', $bmttime)*3600 + date('i', $bmttime)*60 + date('s', $bmttime); // seconds since midnight (BMT)
$ibeats = $ssm/86.4; // 86400 seconds = 1000 beats, so 1 beat = 86.4 seconds
echo 'i.Beats : ' . date('D, d M Y', $bmttime) . ' @' . $ibeats;
?>
Note: If you would try date('D, d M Y @B', $bmttime), the resulting beats would be wrong because the timezone used for calculation of the beats within the date() function is still your local one but the timestamp is UTC+0100. Another working way would be:
<?php
$curtime = time();
$utcdiff = date('Z', $curtime); // get difference to UTC in seconds
$bmttime = $curtime - $utcdiff + 3600; // BMT = UTC+0100
echo 'i.Beats : ' . date('D, d M Y', $bmttime) . ' @' . date('B', $curtime);
?>
But this way there are no floating-point beats possible, which may be handy sometimes.
mendoza at pvv dot ntnu dot no
13-Oct-2005 07:38
13-Oct-2005 07:38
At "daykay at pdsoftware dot de":
09 != 9 so there's nothing wrong about European vs. American formats.
$ php -r 'print 09; print "\n"; print 9; print "\n";'
0
9
09 is treated as octal and since octal numbers only use the 0-7 digits, it evaluates to 0. All numbers prefixed with 0 are considered octal just as 0x are considered hexadecimal.
http://en.wikipedia.org/wiki/Computer_numbering_formats
kbrill at multi dot com
15-Sep-2005 05:27
15-Sep-2005 05:27
I created a routine that fills an array with the dates in the current week. For example $WeekDays[0] is sunday's date, $WeekDays[1] is monday's date and so on no matter what day of the week it is today.
<?php
$lowEnd=date("w");
$lowEnd=-$lowEnd;
$highEnd=$lowEnd + 6;
$weekday=0;
for ($i=$lowEnd; $i<=$highEnd; $i++) {
$WeekDate[$weekday]=date("m/d",mktime(0, 0, 0, date("m") , date("d")+$i, date("Y")));
$weekday++;
}
?>
webmaster [AT] gn-solutions [DOT] de
07-Sep-2005 01:19
07-Sep-2005 01:19
For users who want a different language than english, you can user strftime() function in combination with setlocale() instead of date():
e.g. for german language:
With date you would write:
<?php
echo date('l, d. F Y'); //Output: Wednesday, 07. September 2005
?>
With strftime() you can output it in german like this:
<?php
// Set the gloabal LC_TIME constant to german
setlocale(LC_TIME, 'de_DE');
// Little bit other Syntax but better effect
echo strftime('%A, %d. %B %Y'); //Output: Mittwoch, 07. September 2005
?>
Greetings, Andy!
steve at somejunkwelike dot com
16-Aug-2005 08:01
16-Aug-2005 08:01
re: Paul_liversidge...
This is a way to get the next 10 business days, by comparing the day of the week to not be saturday or sunday. change the top two variables to get various different results... if you want to get the next 10 business days, starting in two days from today, change the first variable to 2, and the second to 14. This should yield the next 10 working days.
<?php
$how_many_business_days_ahead = 0;
$how_many_business_days_to_count = 7;
for ($i=0;$i<$how_many_business_days_to_count;$i++)
{
$jump=$i+$how_many_business_days_ahead;
$evalday = mktime(strftime ("%d/%m/%Y", strtotime("+$jump days")));
$theday = strftime("%A", strtotime("+$jump days"));
if($theday != "Saturday" and $theday != "Sunday")
{
$days = $how_many_business_days_ahead+$i;
$the_days[$j] = strftime("%A, %B %d, %Y", strtotime("+$jump days"));
$j++;
}
}
$k = $how_many_business_days_ahead;
foreach($the_days as $eachday)
{
echo "$k business days from now = $eachday<br />";
$k++;
}
?>
results:
0 business days from now = Tuesday, August 16, 2005
1 business days from now = Wednesday, August 17, 2005
2 business days from now = Thursday, August 18, 2005
3 business days from now = Friday, August 19, 2005
4 business days from now = Monday, August 22, 2005
Rob Muhlestein
05-Aug-2005 07:48
05-Aug-2005 07:48
All functions that have anything to do with the internal 32-bit constrained time() system call will have this same limitation. Hopefully we'll be 64 bit by long before then, although this already creating problems with UNIX internals.
ove at junne dot dk
03-Aug-2005 08:39
03-Aug-2005 08:39
I seems to me that we're rapidly apporaching another Y2K event. The date-function only handles dates up to 2038, and this is only some 30 years away. Even today is it impossible to use date() to represent my children's 50 years birthday.
Just think about it, when you're designing your code.
[ed.: This limitation is gone in PHP 5.1 and higher, although PHP itself limits integers still to 32bit]
stuff at rushsoft dot de
30-Jun-2005 11:13
30-Jun-2005 11:13
ISO 8601:2000 defines:
[...] day of the year is represented by three decimal digits. The first day of any year is represented by [001] and
subsequent days are numbered in ascending sequence [...]
So don't forget increasing the return value of date("z") by one to be ISO conform, if you use this, for instance, on presentation level.
witcho at gmail dot com
07-Jun-2005 06:22
07-Jun-2005 06:22
When using 'z' it should be used as how many days have passed since the beginning of the year; not as the day of the year.
"January 1" is the day 1 of the year not the day 0.
Better to add 1 when using 'z' if you really want to know the day of the year.
MG_Peter at o2 dot pl
30-Apr-2005 02:05
30-Apr-2005 02:05
easy way - to convert a "datetime" form mySQL into php date format....
first - get the array form mySQL, then use
<?php
date("d M Y H:i:s", strtotime($your_row['lastlogin_date']))
?>
strtotime - easy converts a datetime timestamp into time ( time() or date("U")).
llewellyntd at gmail dot com
29-Apr-2005 02:50
29-Apr-2005 02:50
Here is a very easy way to get the difference, in days, between two dates:
$days = (strtotime("2005-12-31") - strtotime(date("Y-m-d"))) / (60 * 60 * 24);
print $days;
jon AT standardise DOT us
15-Feb-2005 05:57
15-Feb-2005 05:57
Don't forget that months start on the 1st day, and not a zero date. Might seem obvious but:
$test = date("F Y", mktime(0, 0, 0, 12, 0, 2005));
Will return November 2005, not December.
$test = date("F Y", mktime(0, 0, 0, 12, 1, 2005));
The 1st is needed to get the right month.
ag nodot nospam at netside dot de
28-Jan-2005 04:19
28-Jan-2005 04:19
Calculus of weeks in a year.
Since there is date("W") many still seem to have a problem regarding how many weeks there are in an year. Some rather complex solutions have been shown here.
It's defined, that a week which begins in december and ends in january the following year belongs to the year where most of its days lie. Therefore a week with at least 4 days in december is the last week of that year and a week with at least 4 days in january is the first week in the new year.
This concludes, that the last week of a year always contains the 28th day of december. So if you take date("W") on that day of a given year you always get the correct number of weeks for that year.
The other end of that definition is that the 4th day of january always lies in the first week of a year.
I hope this solves a lot of confusion.
(For those asking what all this fuzz about counting weeks is about: normally theres 52 weeks in a year but sometimes its 53 weeks in a year)
I wrote it down as a function, but as this is rather trivial one might consider using the date(...) only.
function weeks($year) {
return date("W",mktime(0,0,0,12,28,$year));
}
php at document-root dot de
14-Apr-2004 07:02
14-Apr-2004 07:02
To convert an unix timestamp to suite the syntax of a GeneralizedTime attribute for OpenLDAP, you can use
date ('YmdHiZO'). Note that this conversion uses local time, the recommended way is to store dates in UTC.
If your date is in UTC, just use
date ('YmdHiZ').'Z' to convert it ("Z" stands for "Zulu", which is UTC).
daniel
17-Feb-2004 11:43
17-Feb-2004 11:43
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.
<?
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");
}
?>