--- In firebird-support@yahoogroups.com, "Adam" <s3057043@y...> wrote:

> --- In firebird-support@yahoogroups.com, "shaamim_ply"
> <shaamim_ply@y...> wrote:
> >
> > the dt_start,dt_end are date type fields.
> > pls give me the necesary codes for creating the datetovarchar() UDF
>
> I do not have any pre-written code to do this because I believe that
> formatting is best left to the client application. However, you should
> be able to locate a tutorial on how to write a UDF in your preferred
> language and platform. Most languages have some sort of FormatDateTime
> type function in one of their libraries that you can use internally
> within the UDF. Then it is just a case of declaring it and using it.
>
> Adam

Actually in my case formatting the concatenated date using my language
libray will not b useful.My query should return the formatted date.and
i am not well in writing UDFs.So if any one know abt that pls help me..

My another doubt is is any UDF available in firebird similar to
Oracle's to_char()