Subject Re: [firebird-support] Re: Date Extraction
Author Robert martin
>>2. Is there a slick way to get a textual representation of the month
>>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.
Hi actually you don't need a UDF !

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.

Rob Martin
Software Engineer

phone +64 03 377 0495
fax +64 03 377 0496

Wild Software Ltd

[Non-text portions of this message have been removed]