How do I get the month and day with leading 0's in SQL? (e.g. 9 => 09)

Question

DECLARE @day CHAR(2)  SET @day = DATEPART(DAY, GETDATE())  PRINT @day 

If today was the 9th of December, the above would print "9".

I want to print "09". How do I go about doing this?

Answer 1

Pad it with 00 and take the right 2:

DECLARE @day CHAR(2)  SET @day = RIGHT('00' + CONVERT(NVARCHAR(2), DATEPART(DAY, GETDATE())), 2)  print @day 

Answer 2

For SQL Server 2012 and up , with leading zeroes:

 SELECT FORMAT(GETDATE(),'MM')  

without:

SELECT    MONTH(GETDATE())