| Subject | Re: [firebird-support] 123 to 00123 |
|---|---|
| Author | Helen Borrie |
| Post date | 2011-12-19T03:17:17Z |
At 01:50 PM 19/12/2011, wiyono wrote:
select LPAD (123, 5, '0') bilangan FROM RDB$DATABASE
./hb
>In Oracle ;In v.2.5 and 2.1.4:
>
>SELECT TO_CHAR(123,'00000') bilangan FROM Dual;
>
>Result is :
>
>Bilangan
>
>00123
>
>How in firbird ?
select LPAD (123, 5, '0') bilangan FROM RDB$DATABASE
./hb