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.

Actually, I am doing this for month, still it will be integer. — hsuk, Mar 21 '13 at 06:39

score 9 · Accepted Answer · answered Mar 21 '13 at 06:29

9

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

answered Mar 21 '13 at 06:29

John Woo

Vishal Suthar · Answer 2 · 2013-03-21T06:43:11.473

4

It would be:

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

Live Demo

edited Mar 21 '13 at 06:43

answered Mar 21 '13 at 06:32

Vishal Suthar

score 0 · Answer 3 · edited May 23 '17 at 10:26

0

There is a way to do what you ask. Here is a post that explains it, assuming you are using SQL Server

edited May 23 '17 at 10:26

Community

answered Mar 21 '13 at 06:33

someuser