| Subject | Re: [firebird-support] Preceding Zero for a Month extracted from a Date |
|---|---|
| Author | Christian Gütter |
| Post date | 2005-08-18T10:50:14Z |
Hi Ivan,
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
> CASE WHEN EXTRACT(MONTH FROM PA.StartDate)<10 THEN 0 ELSE '' ENDAwesome, that works!
> || EXTRACT(MONTH FROM PA.StartDate)
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