- var_dump: documentation ( source)
- ini_get: documentation ( source)
- date_default_timezone_get: documentation ( source)
<?php
//$connection = mysql_connect('localhost', 'root','abcABC123');
//mysql_select_db('pearson', $connection);
//ini_set('date.timezone', 'US/Eastern');
//date_default_timezone_set('Europe/London');
echo "PHP INI SETTING : " . ini_get('date.timezone') . "</br>";
echo "Current timezone: " . date_default_timezone_get() . "</br>";
$date = new DateTime();
var_dump(new DateTime());
echo "</br>------------------------------------ DateTime Constants -------------------------------------------------</br>";
echo "DATE_ATOM - " . $date->format(DATE_ATOM) . "</br>" ;
echo "DATE_ISO8601 - " . $date->format(DATE_ISO8601) . "</br>" ;
echo "DATE_RFC822 - " . $date->format(DATE_RFC822) . "</br>" ;
echo "DATE_RSS - " . $date->format(DATE_RSS) . "</br>" ;
echo "</br>-------------------------------------- Operation with Date -----------------------------------------------</br>";
echo "Offset to GMT - " . $date->getOffset() . "</br>" ;
echo "Date modify - " . $date->modify('+2 week')->format(DATE_RSS) . "</br>" ;
echo "</br>-------------------------------------- Operation with Timezone -----------------------------------------------</br>";
echo "http://www.php.net/manual/en/datetime.configuration.php#ini.date.timezone </br>" ;
echo "Timestamp - " . $date->getTimestamp(). "</br>" ;
$timeZone = new DateTimeZone("Europe/Moscow");
$date->setTimezone($timeZone);
//var_dump($timeZone->getTransitions());
//var_dump(timezone_identifiers_list());
var_dump($date);
echo "Timezone offset to GMT - " . $timeZone->getOffset(new DateTime()) . "</br>" ;
echo "</br>-------------------------------------- MYSQL -----------------------------------------------</br>" ;
$sql = "INSERT INTO date_date(my_timestamp, datetime) VALUES(\"". CURRENT_TIMESTAMP . "\",\"" . $date->format("d-m-y H:i:s") . "\")";
echo $sql . "</br>";
mysql_query($sql);
$result = mysql_query('SELECT datetime FROM date_date');
while ($row = mysql_fetch_assoc($result)) {
$userTimeZone = new DateTimeZone('Europe/Oslo');
if (!empty($row["datetime"])) {
$dt = new DateTime($row["datetime"]);
$dt->setTimezone($userTimeZone);
echo "</br>" . $dt->format("r") . "</br>";
}
}
echo "</br>-------------------------------------- Prooof links-----------------------------------------------</br>" ;
echo "http://www.worldtimezone.com/index24.php </br>" ;
echo "http://www.sitepoint.com/forums/showthread.php?450107-Difference-between-GMT-and-PST#post3243632</br>" ;