Need 2 digit Month returned; not 1 digit!! 1

[Guest_imported]

(Xcata thankyou for the previous solution!!)

How can I return a 2 digit month into a variable for the months Jan thru September

SELECT DATEPART(mm, GETDATE()) ---> returns 9 for September.. I need 09 returned in order to properly build my target file name...

Thx,
BT

 

[stevetodd]

try this

select substring(convert(varchar(10),getdate(),102),6,2)

Steve