PHPackages                             dukecity/doctrineextensions - PHPackages - PHPackages  [Skip to content](#main-content)[PHPackages](/)[Directory](/)[Categories](/categories)[Trending](/trending)[Leaderboard](/leaderboard)[Changelog](/changelog)[Analyze](/analyze)[Collections](/collections)[Log in](/login)[Sign up](/register)

1. [Directory](/)
2. /
3. [Database & ORM](/categories/database)
4. /
5. dukecity/doctrineextensions

ActiveLibrary[Database & ORM](/categories/database)

dukecity/doctrineextensions
===========================

A set of extensions to Doctrine 2 that add support for additional query functions available in MySQL, Oracle, PostgreSQL and SQLite.

v2.0.2(2y ago)833.3k↓26.9%4[5 issues](https://github.com/Dukecity/DoctrineExtensions/issues)[4 PRs](https://github.com/Dukecity/DoctrineExtensions/pulls)BSD-3-ClausePHPPHP ^8.1

Since May 16Pushed 1y agoCompare

[ Source](https://github.com/Dukecity/DoctrineExtensions)[ Packagist](https://packagist.org/packages/dukecity/doctrineextensions)[ RSS](/packages/dukecity-doctrineextensions/feed)WikiDiscussions master Synced 3w ago

READMEChangelog (3)Dependencies (7)Versions (58)Used By (0)

DoctrineExtensions
==================

[](#doctrineextensions)

[![Build Status](https://camo.githubusercontent.com/3fa4dd6b22d6ba39b4a6124ce262c7035f01b66bbcdce677bdbdb53665592249/68747470733a2f2f696d672e736869656c64732e696f2f62616467652f6272616e63682d6d61737465722d626c75652e737667)](https://github.com/Dukecity/DoctrineExtensions/tree/master)[![Build Status](https://github.com/Dukecity/DoctrineExtensions/workflows/Tests/badge.svg)](https://github.com/Dukecity/DoctrineExtensions/actions)[![codecov](https://camo.githubusercontent.com/be6cd4a521e752fa2fdbb24f72612dfcfeec015567afcc0141d9c4f19e2d247e/68747470733a2f2f636f6465636f762e696f2f67682f44756b65636974792f446f637472696e65457874656e73696f6e732f6272616e63682f6d61737465722f67726170682f62616467652e7376673f746f6b656e3d4c474b385848385a385a)](https://codecov.io/gh/Dukecity/DoctrineExtensions)[![Packagist](https://camo.githubusercontent.com/a25e0b0116a730521b2f4ea2984c21410755fdf78ab0f3fac0018b4c125a0691/68747470733a2f2f696d672e736869656c64732e696f2f7061636b61676973742f762f44756b65636974792f646f637472696e65657874656e73696f6e732e7376673f6c6162656c3d737461626c65)](https://packagist.org/packages/Dukecity/doctrineextensions)

A set of extensions to Doctrine 2 that add support for functions available in MySQL, Oracle, PostgreSQL and SQLite.

DBFunctionsMySQL`ACOS, ADDTIME, AES_DECRYPT, AES_ENCRYPT, ANY_VALUE, ASCII, ASIN, ATAN, ATAN2, BIN_TO_UUID, BINARY, BIT_COUNT, BIT_XOR, CAST, CEIL, CHAR_LENGTH, COLLATE, CONCAT_WS, CONV, CONVERT_TZ, COS, COT, COUNTIF, CRC32, DATE, DATE_FORMAT, DATEADD, DATEDIFF, DATESUB, DAY, DAYNAME, DAYOFWEEK, DAYOFYEAR, DEGREES, DIV, EXP, EXTRACT, FIELD, FIND_IN_SET, FLOOR, FORMAT, FROM_BASE64, FROM_UNIXTIME, GREATEST, GROUP_CONCAT, HEX, HOUR, IFELSE, IFNULL, INET_ATON, INET_NTOA, INET6_ATON, INET6_NTOA, INSTR, IS_IPV4, IS_IPV4_COMPAT, IS_IPV4_MAPPED, IS_IPV6, JSON_CONTAINS, JSON_DEPTH, JSON_EXTRACT, JSON_LENGTH, JSON_UNQUOTE, LAG, LAST_DAY, LAST_INSERT_ID, LEAD, LEAST, LOG, LOG10, LOG2, LPAD, MAKEDATE, MATCH, MD5, MINUTE, MOD, MONTH, MONTHNAME, NOW, NULLIF, OVER, PERIOD_DIFF, PI, POINT, POWER, QUARTER, RADIANS, RAND, REGEXP, REGEXP_REPLACE, REGEXP_SUBSTR, REPLACE, ROUND, RPAD, SECOND, SECTOTIME, SHA1, SHA2, SIN, SOUNDEX, STD, STDDEV, STRTODATE, ST_DISTANCE_SPHERE, STR_TO_DATE, SUBSTRING_INDEX, TAN, TIME, TIMEDIFF, TIMESTAMPADD, TIMESTAMPDIFF, TIMETOSEC, TRUNCATE, UNHEX, UNIX_TIMESTAMP, UTC_TIMESTAMP, UUID_SHORT, UUID_TO_BIN, VARIANCE, WEEK, WEEKDAY, WEEKOFYEAR, YEAR, YEARMONTH, YEARWEEK`Oracle`CEIL, DAY, FLOOR, HOUR, LISTAGG, MINUTE, MONTH, NVL, SECOND, TO_CHAR, TO_DATE, TRUNC, YEAR`SQLite`CASE WHEN THEN ELSE END, DATE, DATE_FORMAT*, DAY, HOUR, IFNULL, JULIANDAY, MINUTE, MONTH, REPLACE, ROUND, SECOND, STRFTIME, WEEK, WEEKDAY, YEAR`PostgreSQL`AGE, AT_TIME_ZONE, COUNT_FILTER, DATE, DATE_PART, DATE_TRUNC, DAY, EXTRACT, GREATEST, HOUR, ILIKE, LEAST, MINUTE, MONTH, QUARTER, REGEXP_REPLACE, SECOND, STRING_AGG, TO_CHAR, TO_DATE, YEAR`> Note: SQLite date functions are implemented as `strftime(format, value)`. SQLite only supports the [most common formats](https://www.sqlite.org/lang_datefunc.html), so `date_format` will convert the mysql substitutions to the closest available SQLite substitutions. This means `date_format(field, '%b %D %Y') -> Jan 1st 2023` becomes `strftime('%m %d %Y', field) -> 01 01 2023`.

Installation
------------

[](#installation)

To install this library, run the command below and you will get the latest version:

```
composer require dukecity/doctrineextensions
```

Usage
-----

[](#usage)

If you are using DoctrineExtensions with Symfony read [How to Register custom DQL Functions](https://symfony.com/doc/current/doctrine/custom_dql_functions.html).

You can find example Symfony configuration for using DoctrineExtensions custom DQL functions in [config](config).

If you are using DoctrineExtensions standalone, you might want to fire up the autoloader:

```