Skip to Content
avatar image
Former Member

SAP HANA Format Number String

How to format a number in SAP Hana? For example instead of displaying 1 it should display 01.

In Sap Webi I use FormatNumber([Value];"00").

Is there a similar function in SAP Hana?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Feb 02, 2017 at 05:08 PM

    Hi Ashraf

    We can try something like

    select lpad(1,'2','00') as "PAD" from dummy

    Thanks

    Add comment
    10|10000 characters needed characters exceeded