At 02:14 PM 9/05/2006, Robert martin wrote:

> >>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.

No need to be embarrassed about it...but it can't be used like a function.

./heLen

>Rob Martin
>Software Engineer
>
>phone +64 03 377 0495
>fax +64 03 377 0496
>web www.chreos.com
>
>Wild Software Ltd
>
>
>
>
>[Non-text portions of this message have been removed]
>
>
>
>
>++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
>Visit http://firebird.sourceforge.net and click the Resources item
>on the main (top) menu. Try Knowledgebase and FAQ links !
>
>Also search the knowledgebases at http://www.ibphoenix.com
>
>++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
>Yahoo! Groups Links
>
>
>
>