Is there any alternative to mysql NOW() function?

Maybe you could add IF function like this?

Or maybe copy from this abandoned repository?

As I can't find documentation explaining how to use the functions, I'm not able of running
->andWhere("(DateOfYear(u.birthday)-DateOfYear(:today)) >0")

The error I'm getting is:
ClassNotFoundException: Attempted to load class "DateOfYear" from namespace "Luxifer\DQL\Datetime" in /Users/a77/Documents/DEV/UVox Com/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php line 3096. Do you need to "use" it from another namespace?

So which use sentence I need to include on my repository file?
Thanks in advance

It looks like https://github.com/luxifer/doctrine-functions/blob/master/src/DQL/String/ConcatWs.php#L3 possibly violates a reserved word of string as defined here: http://php.net/manual/en/reserved.other-reserved-words.php.

Are these reserved words case-insensitive?

SQLite is frequently used instead of MySQL for unit testing.

But some functions differ.

Would you be interested by Pull Requests for SQLite alternatives?

This is a quite easy implement, for example with YEAR:

public function getSql(SqlWalker $sqlWalker)
{
    if ($sqlWalker->getConnection()->getDriver() instanceof AbstractSQLiteDriver) {
        return "DATE('%Y', {$this->dateExpression->dispatch($sqlWalker)})";
    }

    return 'YEAR('.$this->dateExpression->dispatch($sqlWalker).')';
}

What do you think?

Would I just drop the DQL directory into my Doctrine folder and then continue with installation as you've mentioned?

Hi,
I have been forced to change the config.yml in order to make it work.
This is the right code:

orm:
    dql:
      datetime_functions:
            date:         Luxifer\DQL\Datetime\Date
            datediff:     Luxifer\DQL\Datetime\DateDiff
            dateofmonth:  Luxifer\DQL\Datetime\DateOfMonth
            dateofweek:   Luxifer\DQL\Datetime\DateOfWeek
            dateofyear:   Luxifer\DQL\Datetime\DateOfYear
            week:         Luxifer\DQL\Datetime\Week
            day:          Luxifer\DQL\Datetime\Day
            hour:         Luxifer\DQL\Datetime\Hour
            minute:       Luxifer\DQL\Datetime\Minute
            month:        Luxifer\DQL\Datetime\Month
            quarter:      Luxifer\DQL\Datetime\Quarter
            second:       Luxifer\DQL\Datetime\Second
            time:         Luxifer\DQL\Datetime\Time
            year:         Luxifer\DQL\Datetime\Year
            convert_tz:   Luxifer\DQL\Datetime\ConvertTZ

Hello.

We are using your package in our project and we are going to RC, and we would like to use stable version instead of dev-master
Would it be possible to create "up to date" stable tag ?

Thanks in advance!

Provide some bridges for function auto-loading and configuration would be a nice addition, would not be?

I may provide some PRs for that.