sllh/doctrine-dbal-utc-datetime

UTC DateTime type for Doctrine DBAL

Maintainers

Details

github.com/Soullivaneuh/doctrine-dbal-utc-datetime

Source

Issues

Installs: 35 326

Dependents: 0

Suggesters: 0

Security: 0

Stars: 11

Watchers: 2

Forks: 3

v1.0.0 2017-09-25 19:52 UTC

Requires

Suggests

MIT 7fabe34e104b62f46b9f9582faa178c109c29dd6

  • Sullivan SENECHAL <soullivaneuh.woop@gmail.com>

dbaldoctrinedatetimeutc

This package is auto-updated.

Last update: 2024-12-13 03:22:22 UTC

README

UTC DateTime type for Doctrine DBAL.

Latest Stable Version Latest Unstable Version License

Total Downloads Monthly Downloads Daily Downloads

Build Status Coverage Status

Why this DBAL Type?

This special type allow you to be sure to always save any DateTime to the UTC format.

The goal is to get rid of the quite hazardous timezone management of many database vendors.

For more information, please read the official Doctrine wiki page, where this class come from.

Setup

First of all, you need to require this library through composer:

composer require sllh/doctrine-dbal-utc-datetime

Then, replace the default datetime and datetimetz DBAL types:

use Doctrine\DBAL\Types\Type;
use SLLH\Doctrine\DBAL\Types\UTCDateTimeType;

Type::overrideType('datetime', UTCDateTimeType::class);
Type::overrideType('datetimetz', UTCDateTimeType::class);

If you are using Symfony, you can override the type trough the config.yml file:

doctrine:
    dbal:
        types:
            datetime: SLLH\Doctrine\DBAL\Types\UTCDateTimeType
            datetimetz: SLLH\Doctrine\DBAL\Types\UTCDateTimeType

And voilà! You are good to go. Happy coding!

License

This bundle is under the MIT license. See the complete license on the LICENSE file.