Database Timezone

The Database Timezone bundle contains method to save dates and datetimes values/objects always in the same (custom) timezone in database. This results in an easier datetime/date handling when accessing database values directly or via PHP.

Quick example usage:

Always save dates/times in UTC timezone in database. Change the configuration of /config/packages/database_timezone.yaml to:

database_timezone:
  database: UTC

Table of Contents

• Requirements
• Installation
• Symfony Configuration
• Usage

Requirements

The usage of PHP ≥ v7.4 and Symfony ≥ 5 is recommended.

Installation

Please install via composer.

composer require assistenzde/database-timezone

The bundle will be automatically added to your bundles.yaml configuration.

Symfony Configuration

Please add a database_timezone.yaml file in your configuration directory (i.e. /config/pakcages/) and spcify the timezone to save all datatime values in the database.

database_timezone:
  database: UTC

Usage

All database values will be saved in the configured timezone.