回复: Re: GROUP BY month(date)

[Lei Wu]

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 <[hidden email]>编写：

>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, [hidden email] wrote:
>
>> Jacopo,
>>
>> Sure, I'll test this new patch and let you know the results once it's done.
>>
>> --
>> 发自我的ONEPLUS智能手机
>>
>>
>>
>> Jacopo Cappellato <[hidden email]>编写：
>>
>

[Jacopo Cappellato-4]

It helped indeed! Thank you.

Jacopo

On Nov 29, 2014, at 6:21 AM, [hidden email] wrote:

> 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 <[hidden email]>编写：
>