|Subject||Re: [firebird-support] Re: Date Extraction|
>>2. Is there a slick way to get a textual representation of the monthHi actually you don't need a UDF !
>>and weekday (e.g. 'January' rather than 1)?
>Only with a UDF, e.g. DOW in FBUDF. FreeUDFLib also has some
>functions that return English strings from date types. Appendix 1 of
>the book is a summary of all the UDF syntaxes.
This isn't what Id call slick but you can create a Stored procedure that
takes the number ant returns the text. I have done it and it works
fine. Perhaps I should be embarrassed about that :) In my defense we
have a policy of no Extra UDFs.
phone +64 03 377 0495
fax +64 03 377 0496
Wild Software Ltd
[Non-text portions of this message have been removed]