Subject Re: [firebird-support] Preceding Zero for a Month extracted from a Date
Author Christian G├╝tter
Hi Ivan,

> CASE WHEN EXTRACT(MONTH FROM PA.StartDate)<10 THEN 0 ELSE '' END
> || EXTRACT(MONTH FROM PA.StartDate)

Awesome, that works!

I did not try it because the FB 1.5 release notes say:

a) CASE
Allow the result of a column to be determined by the outcome of a group of exclusive conditions.

Perhaps it should rather say:
"Allow the result of a column or expression to be ..."

Thank you very much for your help!


Christian