Skip to Content
0

SAP HANA Format Number String

Feb 02, 2017 at 11:21 AM

275

avatar image
Former Member

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?

10 |10000 characters needed characters left characters exceeded
Former Member

I'm working on HANA SQL environment.

0
* Please Login or Register to Answer, Follow or Comment.

1 Answer

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

Hi Ashraf

We can try something like

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

Thanks

Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Thank you! :)

0