Did you apply *addCustomDatetimeFunction**( )* to the configuration? As described in that article and a.o. in http://docs.doctrine-project.org/en/latest/cookbook/dql-user-defined-functions.html
Please try more for yourself and study results you can find on the internet before posting here. And if you ask a question, then please add some information what went wrong (like error messages) with the different things you have tried. This is a mailinglist, not a debugger. Thank you. On Monday, 17 February 2014 00:23:16 UTC+1, Parsifal wrote: > > > I searched for month() and found this: > > https://www.simukti.net/blog/2012/04/05/how-to-select-year-month-day-in-doctrine2/ > I copied the saved on site as findOneByYearMonthDay.php and uploaded it > /Doctrine/ORM/DoctrineExtensions then saved Month.php, Day.php, Year.php > and uploaded them to /Doctrine/ORM/DoctrineExtensions/Query/Mysql (as > namespace is so) > then added: > $classLoader = new Doctrine\Common\ClassLoader('DoctrineExtensions', > "Doctrine/ORM/DoctrineExtensions"); > $classLoader->register(); > in bootstrap.php but now I still cannot query "SELECT month(c.joinDate) > FROM Entities\Client c". > Please advice how can I get it worked? and what wrong I did? > > > > > On Mon, Feb 17, 2014 at 12:35 AM, Herman Peeren > <[email protected]<javascript:> > > wrote: > >> When I search on Google for "dql doctrine unix_timestamp" I get 1.300.000 >> results. I only looked at the first 4, which all hint in the same >> direction. You'll probably find a solution there. Please try that first, >> before posting here. Thank you. >> >> >> On Sunday, 16 February 2014 17:08:26 UTC+1, Parsifal wrote: >>> >>> >>> I have difficulty to turn this sql in dq. please help I have a join_date >>> coloumn in clients table (joinDate in entity), and it is a unix timestamp. >>> now how to turn this in dql? for unix_timestamp I can use time() before dql >>> line but how about the rest of it? if not possible how to turn it in >>> NativeSQL? >>> >>> >>> $dql = "SELECT month(from_unixtime(join_date)) AS month, count(*) AS >>> signup, c_status AS status FROM clients WHERE join_date between >>> unix_timestamp('{$year}-01-01') and unix_timestamp('{$year}-12-31 >>> 23:59:59') GROUP BY status, month"; >>> >>> >> -- >> You received this message because you are subscribed to the Google Groups >> "doctrine-user" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected] <javascript:>. >> To post to this group, send email to [email protected]<javascript:> >> . >> Visit this group at http://groups.google.com/group/doctrine-user. >> For more options, visit https://groups.google.com/groups/opt_out. >> > > -- You received this message because you are subscribed to the Google Groups "doctrine-user" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/doctrine-user. For more options, visit https://groups.google.com/groups/opt_out.
