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
To get yesterday’s or tomorrow’s date in timestamp format (PHP), you need to use the standard PHP function "strtotime".
For example, let’s display the time of the current date at 00:00:00 (zero hours, zero minutes, zero seconds):
$t = strtotime('00:00:00');
echo 'Timestamp: '.$t;
echo 'Datetime: '.date('Y-m-d H:i:s',$t);