/**
* Getting the number of days between two dates
*
* @param string $date1 yyyy-mm-dd
* @param string $date2 yyyy-mm-dd
* @return integer
*/
function getDiffInDays($date1,$date2){
$datediff = strtotime($date1)- strtotime($date2);
return floor($datediff/(60*60*24));
}
$days = getDiffInDays('2013-02-15','2013-01-26');
$date1 = strtotime('2010-10-12');
$date2 = strtotime('2011-11-12');
$diff = $date2-$date1;
$days = floor($diff/(60*60*24));
$date1 = strtotime('2010-10-12');
$date2 = strtotime('2011-11-12');
$diff = $date2-$date1;
$days = floor($diff/(60*60*24));
$startDate = '1999-03-12';
$endDate = '2011-03-12';
$days = (strtotime($endDate)-strtotime($startDate)) / (60 * 60 * 24);
echo $days; //Will output 4383
$date = '2010-03-22';
$new_date = date('Y-m-d',strtotime('+4 months',strtotime($date)));
echo $new_date; //Displays 2010-07-22
$date1 = '1999-10-11';
$date2 = '2010-10-11';
$firstDate = strtotime($date1);
$secondDate = strtotime($date2);
if($firstDate < $secondDate){
echo 'First date is older';
}else{
echo 'Second date is older';
}
int strtotime ( string $time [, int $now ] )
$ts = strtotime('2007-12-21');
echo date('Y-m-d', 1198148400);
// echos 2007-12-21
$ts = strtotime('21 december 2007');
echo $ts, '<br />';
echo date('Y-m-d', $ts), '<br />';
1198148400 2007-12-21
$ts = strtotime('next week');
echo $ts, '<br />';
echo date('Y-m-d', $ts), '<br />';
$ts = strtotime('next tuesday');
echo $ts, '<br />';
echo date('Y-m-d', $ts), '<br />';
$ts = strtotime('last thursday');
echo $ts, '<br />';
echo date('Y-m-d', $ts), '<br />';
$ts = strtotime('2 weeks ago');
echo $ts, '<br />';
echo date('Y-m-d', $ts), '<br />';
$ts = strtotime('+ 1 month');
echo $ts, '<br />';
echo date('Y-m-d', $ts), '<br />';
1199006542 2007-12-30 1198494000 2007-12-25 1198062000 2007-12-20 1197192142 2007-12-09 1201080142 2008-01-23
$ts = strtotime('tomorrow', 1198494000);
echo $ts, '<br />';
echo date('Y-m-d', $ts);
1198580400 2007-12-26
$ts = strtotime('2007-10-12 +90 days');
echo $ts, '<br />';
echo date('Y-m-d', $ts), '<br />';
1199876400 2008-01-10
string object in my php array$date = new DateTime("2013-03-05 00:00:00+00");
$date->add("+12 hours");
//then convert back to string or just assign it to a variable within the array node
add() to modify(). add() expects a DateInterval object.<?php
$date = new DateTime("2013-03-05 00:00:00+00");
$date->modify("+12 hours");
echo $date->format("Y-m-d H:i:sO");
<?php
$date = new DateTime("2013-03-05 00:00:00+00");
$date->add(new DateInterval('PT12H'));
echo $date->format("Y-m-d H:i:sO");
echo '<br />1. '.$w_time_no;
echo '<br />2. '.strtotime($w_time_no);
echo '<br />3. '.date('G:i', strtotime($w_time_no));
1. 0000-00-00 22:00:00
2.
3. 2:00
Return ValuesReturns a timestamp on success, FALSE otherwise. Previous to PHP 5.1.0, this function would return -1 on failure.
echo : false is considered as an empty string, and nothing get outputed.Note: The valid range of a timestamp is typically from Fri, 13 Dec 1901 20:45:54 UTC to Tue, 19 Jan 2038 03:14:07 UTC. (These are the dates that correspond to the minimum and maximum values for a 32-bit signed integer.) Additionally, not all platforms support negative timestamps, therefore your date range may be limited to no earlier than the Unix epoch. This means that e.g. dates prior to Jan 1, 1970 will not work on Windows, some Linux distributions, and a few other operating systems. PHP 5.1.0 and newer versions overcome this limitation though.
'0000-00-00' is outside of this range, so it's not considered a valid date ; hence the false return value.
Array
(
[08-12-2015] => Array
(
------------
)
[07-12-2015] => Array
(
------------
)
[09-12-2015] => Array
(
------------
)
)
Array
(
[07-12-2015] => Array
(
------------
)
[08-12-2015] => Array
(
------------
)
[09-12-2015] => Array
(
------------
)
)
function order_date($a1,$b1) {
$format = 'd-m-Y';
$a = strtotime(date_format(DateTime::createFromFormat($format, $a1), 'Y-m-d H:i:s'));
$b = strtotime(date_format(DateTime::createFromFormat($format, $b1), 'Y-m-d H:i:s'));
if ($a == $b)
{
return 0;
}
else if ($a > $b)
{
return 1;
}
else {
return -1;
}
}
uksort($array, "order_date");
Dates in PHP and MySQL
I see a lot of people on forums and on my training courses asking about thebest way (or any way) to manage dates stored in a MySQL database and used in PHP.Three options follow, but first the problem. PHP uses unix timestamps for all its date functionality.It has methods to convert these timestamps into pretty much any text format youcould want but internally it uses the timestamp format. A timestamp is simply an integer.Specifically, it's the number of seconds that have elapsed sincemidnight on January 1st 1970 (greenwich mean time).
MySQL has three date types for use in columns. These are DATETIME, DATE, and TIMESTAMP.
DATETIME columns store date and time in some internal format (I've not found what that is)
for efficiency but always converts them to/from a string in the form YYYY-MM-DD HH:MM:SS
(e.g. 2006-12-25 13:43:15) when accessing them. DATE columns use just the date part of
this format - YYYY-MM-DD (e.g. 2006-12-25). TIMESTAMP columns, despite their name, are
nothing like the unix timestamps used in PHP. A TIMESTAMP column is simply a DATETIME column
that automatically updates to the current time every time the contents of that record are
altered. (That's a simplification but broadly true and the details are not important here).
In particular, since version 4.1 of MySQL the TIMESTAMP format is exactly the same as the
DATETIME format.
So the problem is how to work with these two very different date formats -the PHP timestamp integer and the MySQL DATETIME string. There are three commonsolutions...
- One common solution is to store the dates in DATETIME fields and use PHPs date() and strtotime() functions to convert between PHP timestamps and MySQL DATETIMEs. The methods would be used as follows -
$mysqldate = date( 'Y-m-d H:i:s', $phpdate ); $phpdate = strtotime( $mysqldate );- Our second option is to let MySQL do the work. MySQL has functions we can use to convert the data at the point where we access the database.
UNIX_TIMESTAMPwill convert from DATETIME to PHP timestamp andFROM_UNIXTIMEwill convert from PHP timestamp to DATETIME. The methods are used within the SQL query. So we insert and update dates using queries like this -
$query = "UPDATE table SET datetimefield = FROM_UNIXTIME($phpdate) WHERE..."; $query = "SELECT UNIX_TIMESTAMP(datetimefield) FROM table WHERE...";- Our last option is simply to use the PHP timestamp format everywhere. Since a PHP timestamp is a signed integer, use an integer field in MySQL to store the timestamp in. This way there's no conversion and we can just move PHP timestamps into and out of the database without any issues at all.
Be aware, however, that by using an integer field to store your dates you lose a lot of functionality within MySQL because MySQL doesn't know that your dates are dates. You can still sort records on your date fields since php timestamps increase regularly over time, but if you want to use any of MySQL's date and time functions on the data then you'll need to use FROM_UNIXTIME to get a MySQL DATETIME for the function to work on.
However, if you're just using the database to store the date information and any manipulation of it will take place in PHP then there's no problems.
So finally we come to the choice of which to use. For me, if you don't need to manipulate the dates within MySQL then there's no contest and the last option is the best. It's simple to use and is the most efficient in terms of storage space in the data table and speed of execution when reading and writing the data.
However, some queries will be more complicated because your date is not in a date field (e.g. select all users who's birthday is today) and you may lose out in the long run. If this is the case it may be better to use either option 1 or 2. Which of these you use depends on whether you'd rather place the work on MySQL or PHP. I tend to use option 2 but there's no right or wrong answer - take your pick.
$begin = new DateTime('2013-02-01');
$end = new DateTime('2013-02-13');
$daterange = new DatePeriod($begin, new DateInterval('P1D'), $end);
foreach($daterange as $date){
echo $date->format("Y-m-d") . "<br>";
} $day = 86400; // Day in seconds
$format = 'Y-m-d'; // Output format (see PHP date funciton)
$sTime = strtotime($start_date); // Start as time
$eTime = strtotime($end_date); // End as time
$numDays = round(($eTime - $sTime) / $day) + 1;
$days = array();
for ($d = 0; $d < $numDays; $d++) {
$days[] = date($format, ($sTime + ($d * $day)));
}
![IVRAMANA](https://draft.blogger.com/img/profile_blank_gray.jpg" title="IVRAMANA)
Hello Friends! I am Ramana a part time blogger from Hyderabad.
Posts
