SQL function 2 digit number formatting

Question

Is there any SQL function to convert the number in two digit numbers so, I can get 01 for 1.

Answer 1

You need to convert the value into string. You can use LPAD() for this,

• SQLFiddle Demo
• LPAD()

Answer 2

It would be:

SELECT LPAD(1, 2, '0');

Live Demo