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
|
|