Subject | Re: SQL Extract problem - Monthly ordered Qty |
---|---|
Author | Alexander V.Nevsky |
Post date | 2003-10-22T18:21:55Z |
--- In firebird-support@yahoogroups.com, "Tanz Anthrox"
<tanz_anthrox@h...> wrote:
evident trik - place it within call to any UDF which can't disfigure
result, for example
Select Abs(Extract (Month From Column)), ...
Group By Abs(Extract (Month From Column))
you use.
Best regards,
Alexander.
<tanz_anthrox@h...> wrote:
> ERR=Invalid token Column 1In FB1 you can't group by built-in function but can by UDF. So
>
> I think it comes with firebird 1.5 that I do not have :))
evident trik - place it within call to any UDF which can't disfigure
result, for example
Select Abs(Extract (Month From Column)), ...
Group By Abs(Extract (Month From Column))
> How can I learn the version of Server in Delphi?Depending on used connectivity components.
> or any external command?any interactive tool should have this option. Depending which one do
you use.
Best regards,
Alexander.