Order website or plugin development for WordPress, website development on the Laravel, Symfony, or Yii2 framework…
Since there is no such built-in function in PHP, I had to write my own implementation:
function get_seconds_to_midnight()
{
$left_day_hh = 23 - intval(date('H'));
$left_day_mm = 59 - intval(date('i'));
$left_day_ss = 60 - intval(date('s'));
return 3600 * $left_day_hh + 60 * $left_day_mm + $left_day_ss;
}To get an array of all time zones with their time offset from Greenwich, use the following function:
function get_time_timezones()
{
$zones_array = array();
$timestamp = time();
$default_timezone = date_default_timezone_get();
$timezone_list = timezone_identifiers_list();
foreach ($timezone_list as $zone)
{
date_default_timezone_set($zone);
$zones_array[$zone] = date('P', $timestamp);
}
date_default_timezone_set($default_timezone);
return $zones_array;
}
To convert a date in the format YYYY-MM-DD HH:MM:SS to a purely numeric date (i.e., a timestamp), you need to use the MySQL function UNIX_TIMESTAMP.
Example:
SELECT UNIX_TIMESTAMP('2017-05-22 14:20:05') `new_date`Result — 1495452005
The same query, but without the time part:
SELECT UNIX_TIMESTAMP('2017-05-22') `new_date`Result — 1495400400