Add leading zero when number is less than 10?

Hi there,

My database is MySQL and I have a sql query which returns the month and I want to add 0 before the single digit month.

select distinct monthname,onthNumberOfYearfrom datedimension p 
where datekey >= 13990101

DatabasesSQLMySQL Server

Last Comment

slightwv (䄆 Netminder)

8/22/2022 - Mon

ASKER CERTIFIED SOLUTION

5/16/2021

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

slightwv (䄆 Netminder)

5/17/2021

Yes, you could do it with two function calls. I can probably come up with a way to use even more than two.

Normally you do it with one: LPAD.

https://dev.mysql.com/doc/refman/8.0/en/string-functions.html#function_lpad

lpad(MonthNumberOfYearfrom ,2,'0')