Subject Re: [ib-support] udf crashes firebird
Author Nick Upson
>From: "Ivan Prenosil" <prenosil@...>

>1) how does your UDF declaration look like ?
> Do you use
> ... RETURNS INTEGER BY VALUE; ?

that was it

>2) There is EXTRACT built-in function (not in IB4, IB5 though),
> to return Monday = 1, .. Sun = 7, use it that way
> EXTRACT(WEEKDAY FROM my_date_field - 1) + 1

using FB1.0.2 but I can't get EXTRACT(WEEKDAY FROM 'today'- 1) + 1 to work

_________________________________________________________________
Use MSN Messenger to send music and pics to your friends
http://www.msn.co.uk/messenger