The Ultimate Guide to High Availability with MariaDB

Comments - FORMAT

8 years ago tino BuanaLabel
How to Create Custom format

Dear Mr / Mrs,

How to create custom format to get the result like below:

Number

1 2 56

Result of Number

001 002 056

I know the format on access : format(number,'000') but i don't know on mariaDB

Thank You Agustino

 
8 years ago Ian Gilfillan
Re: How to Create Custom format

You could use LPAD, for example:

SELECT LPAD(56,3,0);
+--------------+
| LPAD(56,3,0) |
+--------------+
| 056          |
+--------------+
 
8 years ago tino BuanaLabel
Re: How to Create Custom format

Thank you for reply

 
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.