Subject Re: fbudf - dow syntax
Author Alex
--- In firebird-support@yahoogroups.com, "Dimitry Sibiryakov"
<SD@t...> wrote:
> On 24 Sep 2003 at 17:09, Alex wrote:
>
> >unfortunately I can't exactly tell anymore from which UDF I got the
> >dow function which worked on my server. after installation of RC6 I
> >deleted all my UDFs and used the original ones which came with RC6
> >(ib_udf and fbudf). I will give it a try to find and compile the
> >sources of fbudf for myself. maybe i can trace down a little bit more
> >why fb-server crashes on my box.
>
> Letting along your question, I'd like to ask: why you don't use
> EXTRACT() with WEEKDAY param?
>
> SY, Dimitry Sibiryakov.

Because I did not know Firebird supporting EXTRACT(). But thanks for
info, good to know and it works :). Just a little thing, EXTRACT()
returns the weekday number, but DOW returns the weekday as String
(Monday,...). Ok, I can use the new CASE WHEN to convert weekday
numbers into strings.

But nevertheless, DOW udf crashing server is not fine.