Subject Re: SQL Extract problem - Monthly ordered Qty
Author Alexander V.Nevsky
--- In firebird-support@yahoogroups.com, "Tanz Anthrox"
<tanz_anthrox@h...> wrote:
> ERR=Invalid token Column 1
>
> I think it comes with firebird 1.5 that I do not have :))

In FB1 you can't group by built-in function but can by UDF. So
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.