Doctrine Functions for PostgreSQL

This package contains doctrine functions for PostgreSQL., _(*1)

List of available functions:, _(*2)

DAYOFWEEK(expr)
WEEK(expr)
DAYOFMONTH(expr)
DAYOFYEAR(expr)
HOUR(expr)
MINUTE(expr)
MONTH(expr)
QUARTER(expr)
SECOND(expr)
YEAR(expr)

Edit this file in your pull request to add your functions to the list., _(*3)

Install

Via Composer, _(*4)

``` bash $ composer require gesdinet/doctrine-functions-psql, _(*5)


## Usage

### 1) Doctrine Only

According to the [Doctrine documentation](http://docs.doctrine-project.org/en/2.0.x/cookbook/dql-user-defined-functions.html "Doctrine documentation") you can register the functions in this package this way.

```php
<?php
$config = new \Doctrine\ORM\Configuration();
$config->addCustomDatetimeFunction('year', 'Gesdinet\DQL\Datetime\Year');

$em = EntityManager::create($dbParams, $config);

2) Using Symfony 2

With Symfony 2 you can register your functions directly in the config.yml file., _(*6)

doctrine:
    orm:
        dql:
            datetime_functions:
                month:     Gesdinet\DQL\Datetime\Month
                year:      Gesdinet\DQL\Datetime\Year
                # etc