Skip to Content
0

SAP HANA Format Number String

Feb 02, 2017 at 11:21 AM

194

avatar image

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

I'm working on HANA SQL environment.

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

1 Answer

Best Answer
Mrityunjay Pandey 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

Thank you! :)

0