Subject | Re: fbudf - dow syntax |
---|---|
Author | Alex |
Post date | 2003-09-25T10:44:47Z |
--- In firebird-support@yahoogroups.com, "Dimitry Sibiryakov"
<SD@t...> wrote:
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.
<SD@t...> wrote:
> On 24 Sep 2003 at 17:09, Alex wrote:Because I did not know Firebird supporting EXTRACT(). But thanks for
>
> >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.
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.