Subject | Re: [firebird-support] group by week |
---|---|
Author | Lee Jenkins |
Post date | 2003-10-18T06:00:41Z |
james_027 wrote:
Is this correct anyone? If not, I usually make a view using FreeUDFLib
and its functions like F_DAYOFWEEK and then create a query based on that
view that groups by the return value of that function.
Always been kind of a pain to do that way...but...
I'm sure someone more knowledgeable will respond as well.
Lee
> doesn't anybody here an an idea how to do the group by week selectI think I heard somewhere that FB now lets you group by udf functions?
> sql?
>
> thanks
Is this correct anyone? If not, I usually make a view using FreeUDFLib
and its functions like F_DAYOFWEEK and then create a query based on that
view that groups by the return value of that function.
Always been kind of a pain to do that way...but...
I'm sure someone more knowledgeable will respond as well.
Lee