Tag Archives: Date

The difference between MySQL CURDATE() and NOW()

CURDATE() returns the DATE part of the current time.
NOW() returns the date and time portions as a timestamp in various formats, depending on how it was requested

Example

mysql> SELECT NOW(),CURDATE(),CURTIME();
+———————+————+———–+
| NOW() | CURDATE() | CURTIME() |
+———————+————+———–+
| 2012-06-18 14:14:01 | 2012-06-18 | 14:14:01 |
+———————+————+———–+
1 row in set (0.03 sec)

Share

timezone_open

It ia an alias of DateTimeZone::__construct()and it creates new DateTimeZone object
Example

<?php
$date = date_create( ‘2007-05-17’);
$timezone = timezone_open ( ‘Australia/Perth’ );
date_timezone_set( $date, $timezone );
$dateTimeZone = date_timezone_get($date);
echo ‘TimeZone is ‘. timezone_name_get($dateTimeZone);
?>

Output

TimeZone is Australia/Perth

Share

DateTimeZone::getTransitions

It returns all transitions for the timezone
Example

<?php
echo “<pre>”;
$tz = new DateTimeZone(“Europe/London”);
$tzTransitions = $tz ->getTransitions();
print_r(array_slice($tzTransitions, 0, 2));
?>

Output

Array
(
[0] => Array
(
[ts] => -2147483648
[time] => 1901-12-13T20:45:52+0000
[offset] => 3600
[isdst] => 1
[abbr] => BST
)

[1] => Array
(
[ts] => -1691964000
[time] => 1916-05-21T02:00:00+0000
[offset] => 3600
[isdst] => 1
[abbr] => BST
)

)

Share

timezone_name_get

Its an alias of DateTimeZone::getName()and returns the name of the timezone
Example

<?php
$date = date_create(‘2007-05-17’);
$timezone = timezone_open ( ‘Australia/Perth’ );
date_timezone_set( $date, $timezone );
$dateTimeZone = date_timezone_get($date);
echo ‘TimeZone is ‘. timezone_name_get($dateTimeZone);
?>

Output

TimeZone is Australia/Perth

Share

DateTimeZone::getName

It returns the name of the timezone
Example

<?php
$date = new DateTime(‘2007-05-17’);
$timezone = timezone_open ( ‘Australia/Perth’ );
$date->setTimezone( $timezone );
echo ‘TimeZone is ‘. $timezone->getName();
?>

Output

TimeZone is Australia/Perth

Share