via composer
$ composer require nanaweb/doctrine-date-function-extension:dev-master@dev
NOTE: If your app is based on SQLite, please change namespaces below from "MySql" to "SQLite3".
$config = new \Doctrine\ORM\Configuration();
$config->addCustomDatetimeFunction('month', '\Nanaweb\Doctrine\DateFunctionExtension\MySql\Month');
$config->addCustomDatetimeFunction('weekday', '\Nanaweb\Doctrine\DateFunctionExtension\MySql\Weekday');
$config->addCustomDatetimeFunction('year', '\Nanaweb\Doctrine\DateFunctionExtension\MySql\Year');
$config->addCustomDatetimeFunction('weekofyear', '\Nanaweb\Doctrine\DateFunctionExtension\MySql\WeekOfYear');
$em = EntityManager::create($dbParams, $config);
Configure functions in config.yml
.
orm:
# ...
entity_managers:
default:
# ...
dql:
datetime_functions:
month: \Nanaweb\Doctrine\DateFunctionExtension\MySql\Month
weekday: \Nanaweb\Doctrine\DateFunctionExtension\MySql\Weekday
year: \Nanaweb\Doctrine\DateFunctionExtension\MySql\Year
weekofyear: \Nanaweb\Doctrine\DateFunctionExtension\MySql\WeekOfYear