Comments - FORMAT
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.
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
You could use LPAD, for example:
Thank you for reply