shapecode/doctrine-dbal-datetimeutc

A custom Doctine DBAL type to use PHP DateTime objects set to the UTC timezone.

3.1.0 2022-05-29 17:04 UTC

This package is auto-updated.

Last update: 2023-01-29 18:41:17 UTC


README

paypal

PHP Version Latest Stable Version Latest Unstable Version Total Downloads Monthly Downloads Daily Downloads License

A Doctrine DBAL Custom Mapping Type allowing the use of PHP DateTime objects automatically set to the UTC timezone.

Databases suck at timezones. The best way to deal with this is to store the date and time in UTC and separately store the timezone that should be used for display purposes. By default, PHP will create DateTime objects set the server's timezone. This custom type overrides this to set the timezone to UTC, allowing you to later convert to the proper timezone for display.

Install via composer:

composer req shapecode/doctrine-dbal-datetimeutc

Add the custom type before instantiating your entity manager:

use Doctrine\DBAL\Types\Type;
use Shapecode\Doctrine\DBAL\Types\DateTimeUTCType;

Type::addType(DateTimeUTCType::DATETIMEUTC, DateTimeUTCType::class);

Enjoy!