Jacopo, I tested the patches again on the ofbiz instance configured with postgresQL database, the patches worked pretty well. Although I did not have the chance to test them under oracle or MySql, I guess the patches should work fine for these two DBMS since they both also support SQL grammar EXTRACT(YEAR/MONTH/DAY FROM ...). Anyway, that's what I got till now. Hope it helps.
-- 发自我的ONEPLUS智能手机 Jacopo Cappellato <jacopo.cappell...@hotwaxmedia.com>编写: >Thank you! >It would be even better if you could test the latest patch I have attached to >Jira: > >https://issues.apache.org/jira/secure/attachment/12683398/OFBIZ-5146.patch > >This last one also supports the "day" function. > >Regards, > >Jacopo > >On Nov 25, 2014, at 4:56 AM, wulei.bj...@gmail.com wrote: > >> Jacopo, >> >> Sure, I'll test this new patch and let you know the results once it's done. >> >> -- >> 发自我的ONEPLUS智能手机 >> >> >> >> Jacopo Cappellato <jacopo.cappell...@hotwaxmedia.com>编写: >> >