Vectorface\MySQLite\MySQL\DateTime

Complexity

Total Complexity

5

Size/Duplication

Total Lines	45
Duplicated Lines	0 %

Test Coverage

Coverage

100%

Importance

Changes	3
Bugs	1	Features	0

3 Methods

Rating	Name	Duplication	Size	Complexity
A	mysql_now()	0	3	1
A	mysql_to_days()	0	10	1
A	mysql_unix_timestamp()	0	9	3

<?php

namespace Vectorface\MySQLite\MySQL;

/**
 * Provides Date and Time MySQL compatibility functions for SQLite.
 *
 * http://dev.mysql.com/doc/refman/5.7/en/date-and-time-functions.html
 */
trait DateTime
{
    /**
     * NOW - Return the current date and time
     *
     * @return string The current timestamp, in MySQL's date format.
     */
    public static function mysql_now()
    {
        return date("Y-m-d H:i:s");
    }

    /**
     * TO_DAYS - Return the date argument converted to days
     *
     * @param string $date A date to be converted to days.
     * @return int The date converted to a number of days since year 0.
     */
    public static function mysql_to_days($date)
    {
        // Why does this work on my Debian machine with PHP 5.6, and not on Travis?
        // - strtotime("0000-12-31") yields -62135665200
        // - 60 * 60 * 24 is 86400 (seconds)
        // - 1413108827 / 86400 = -719162.79166667, python similarly says -719162.7916666666
        // - ceil bumps it up 1 to -719162
        // - 719527 + (-719162), python agrees
        // - So why is Travis giving me 364?!? Their PHP is configured for a different timezone (I think)!
        return intval(719528 + ((strtotime($date) - date("Z")) / (60 * 60 * 24)));
    }

    /**
     * UNIX_TIMESTAMP - Return a UNIX timestamp
     *
     * @param string $date The date to be converted to a unix timestamp. Defaults to the current date/time.
     * @return int The number of seconds since the unix epoch.
     */
    public static function mysql_unix_timestamp($date = null)
    {
        if (!isset($date)) {
            return time();
        } elseif (count_chars(str_replace([":", "-", " "], "", $date), 3) === "0") {
            return 0; /* MySQL's implementation returns zero for 0000-00-00 00:00:00 and similar */
        }

        return strtotime($date);
    }
}