Subject Re: [firebird-support] Preceding Zero for a Month extracted from a Date
Author Milan Babuskov
Christian G├╝tter wrote:
> within a bigger select statement, I am using
> the following code to extract the month out
> of a given date and then to concatenate the
> date in a different format:
> ...
> EXTRACT(MONTH FROM PA.StartDate) AS StartMonth || '.' ||
> ...
> In this case, e.g. August is extracted as '8', but I would
> like to have months smaller then October shown
> with a preceding zero, e.g. '08' for August.

You can use DateToStr UDF from rfunc UDF library to format the date as
you wish:

Milan Babuskov