adrenalinkin/doctrine-utc-date-time

Provides Doctrine DBAL date and time types for storing in UTC format into database

v2.0.0 2022-08-21 18:32 UTC

Requires

• php: ^7.1 || ^8.0
• doctrine/dbal: ^2.7 || ^3.0

Requires (Dev)

• phpunit/phpunit: ^7.0 || ^8.0 || ^9.0

MIT

• Viktor Linkin

• doctrine-dbal
• symfony-component
• doctrine-utc
• utc-datetime

README

Introduction

Component contains DBAL types for date and time and can be registered as Doctrine types. DBAL types provides functionality for storing date and time into database in the UTC. List of the available types:

• UtcDateTimeType.php
• UtcDateType.php
• UtcTimeType.php

Installation

Open a command console, enter your project directory and execute the following command to download the latest stable version of this component:

    composer require adrenalinkin/doctrine-utc-date-time

This command requires you to have Composer install globally.

Usage

For registration new Doctrine type use official instruction How to Use Doctrine DBAL.

For registration new separate UTC types:

# app/config/config.yml
doctrine:
    dbal:
        types:
            utc_date:     Linkin\Component\DoctrineUTCDateTime\DBAL\Types\UtcDateType
            utc_datetime: Linkin\Component\DoctrineUTCDateTime\DBAL\Types\UtcDateTimeType
            utc_time:     Linkin\Component\DoctrineUTCDateTime\DBAL\Types\UtcTimeType

Also, you can overwrite standard types:

# app/config/config.yml
doctrine:
    dbal:
        types:
            date:     Linkin\Component\DoctrineUTCDateTime\DBAL\Types\UtcDateType
            datetime: Linkin\Component\DoctrineUTCDateTime\DBAL\Types\UtcDateTimeType
            time:     Linkin\Component\DoctrineUTCDateTime\DBAL\Types\UtcTimeType

License