You can calculate SELECT CAST((actual_date - start_date)/7 AS INTEGER),
it returns to you the week number from an initial date, this integer
value you can use "group by", "order by" or anything else, we used this
solution in some reports and it works fine.

On Sat, 2003-10-18 at 03:00, Lee Jenkins wrote: james_027 wrote:

> doesn't anybody here an an idea how to do the group by week select
> sql?
>
> thanks

I think I heard somewhere that FB now lets you group by udf functions?
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



Yahoo! Groups Sponsor
ADVERTISEMENT
click here

To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com



Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

--
_____________________________________________________________________
Max Wolfring - mwolfring@... - Linux/FreeBSD & Gnome