TimeInterval type plugin for CakePHP

v0.2.0 2019-04-24 01:42 UTC

This package is auto-updated.

Last update: 2021-04-20 13:23:32 UTC


Software License Build Status Codecov Latest Stable Version

This plugin provide time_interval custom type for MySQL's TIME, Postgres's INTERVAL, and provide time_interval_int custom type for seconds as INTEGER. This is a custom type to represent intervals, which CakePHP can treat as a TimeInterval object that inherits from DateInterval.


You can install this plugin into your CakePHP application using composer.

The recommended way to install composer packages is:

composer require elstc/cakephp-time-interval

Load plugin

(CakePHP >= 3.6.0) Load the plugin by adding the following statement in your project's src/Application.php:


(CakePHP <= 3.5.x) Load the plugin by adding the following statement in your project's config/bootstrap.php file:

Plugin::load('Elastic/TimeInterval', ['bootstrap' => true]);


Add column definitions to Table class

use Cake\Database\Schema\TableSchema;

class WorkTimesTable extends Table
    protected function _initializeSchema(TableSchema $schema)

        $schema->setColumnType('duration', 'time_interval');
        // CakePHP <= 3.4.x use columnType() instead.
        $schema->columnType('duration', 'time_interval');

        // If your column type is seconds as INTEGER, Use `time_interval_int` instead.
        $schema->setColumnType('duration_sec', 'time_interval_int');

        return $schema;

Add column validation to Table class

Use timeInterval rule instead of time. The timeInterval rule is in the timeInterval validation provider.

use Cake\Validation\Validator;
use Elastic\TimeInterval\Validation\TimeIntervalValidation;

class WorkTimesTable extends Table
    public function validationDefault(Validator $validator)
        // ...

        // CakePHP <= 3.4.x required setProvider. CakePHP >= 3.5 it's not necessary.
        $validator->setProvider('timeInterval', TimeIntervalValidation::class);

        $validator->add('duration', 'timeInterval', [
            'rule' => 'timeInterval',
            'provider' => 'timeInterval',

        return $validator;

In addition, add mutator to Entity class, it is useful.

use Cake\Database\Type;

class WorkTime extends Entity
    protected function _setDuration($value)
        // convert to TimeInterval
        return Type::build('time_interval')->marshal($value);

$workTime->duration = '00:15:00';
$workTime->duration = ($startTime)->diff($endTime); // $startTime, $endTime is FrozenTime object.
$workTime->duration = 3600; // as a seconds


MySQL TIME column limitation.

MySQL :: MySQL 5.7 Reference Manual :: 11.3.2 The TIME Type

By default, values that lie outside the TIME range but are otherwise valid are clipped to the closest endpoint of the range. For example,
'-850:00:00' and '850:00:00' are converted to '-838:59:59' and '838:59:59'. Invalid TIME values are converted to '00:00:00'.
Note that because '00:00:00' is itself a valid TIME value, there is no way to tell, from a value of '00:00:00' stored in a table,
whether the original value was specified as '00:00:00' or whether it was invalid.

DateInterval / TimeInterval construct with date part will be broken time

If you initialize DateInterval with date part, time will not be interpreted correctly.

$workTime->duration = new DateInterval('PT75H4M5S'); // OK
$workTime->duration = new DateInterval('P1M2DT3H4M5S'); // can't get expected time