Firebird

I think also formatting dates on the server is not a big deal.
But are many another simple examples where simple functions are usefull:

Give to me the sales by month ?

select Month(OrderDate) , Sum(TotalValue)
from Orders
group  by Month(OrderDate)

How many bills i will need pay next three months ?

select  Month(BillDate), Coun(*), Sum(BillValue)
from    Bills
where   BillDate  <= AddMonth(CURRENT_DATE, 3)
gropu   by Month(BillDate)


----- Original Message -----
From: "hamacker" <hamacker@...>
To: <firebird-devel@...>
Sent: Tuesday, April 29, 2003 11:10 AM
Subject: Re: [Firebird-devel] Is not possible to add all functions fb_udf (or
else) into FB core


| It date format was example, some times we need to create stored
| procedure, triggers, views, simple text reports,... the important is
| "programming in server-side" without dependences with UDFs for simple
| functions.
| Only this, not more, not less.
| I agree with you that "my preference is for the Firebird team to keep it
| as small and simple as possible", but "simple" is different to be "less
| functions", "less size", "less footprint". "Simple" for me as the same
| "easy to make", simple functions on Firebird would let me glad :)
|
| Thanks.
|
|
| Steve Summers wrote:
|
| > I'm still confused about why you would need to format dates on the server
| > side and turn them into strings. What client side query tool are you using?
| > I use Delphi for programming, and IBExpert Personal edition for admin and
| > ad-hoc querying. Both let you specify the format to show (and edit) dates
| > and times.
|
|
|
|
| -------------------------------------------------------
| This sf.net email is sponsored by:ThinkGeek
| Welcome to geek heaven.
| http://thinkgeek.com/sf
|

Juarez Rudsatz wrote:

> select Month(OrderDate) , Sum(TotalValue)
> from Orders
> group  by Month(OrderDate)

  Juarez, can't you check documentation about Extract internal function
when next time you'll want to group by both Month and Year? ;) Nothing
personal, but I'm afraid traffic here became too large and our
developers have difficulties exchanging information on their work.

Best regards, Alexander V.Nevsky.

Uhhhhh

> I think also formatting dates on the server is not a big deal.
> But are many another simple examples where simple functions are usefull:
> 
> Give to me the sales by month ?
> 
> select Month(OrderDate) , Sum(TotalValue)
> from Orders
> group  by Month(OrderDate)

You can do :

SELECT
  EXTRACT(MONTH FROM OrderDate),
  SUM(TotalValue)
FROM
  Orders
GROUP BY
  EXTRACT(MONTH FROM OrderDate)
 
Regards,
Arno Brinkman