How to get datepart month with 2 numbers

[timscronin]

I understand how datepart works. However, if I am asking for the month datepart(month,getdate()) is there a way to force the months to be 2 digits (say for January be 01 instead of 1)

 

[tlbroadbent]

Datepart returns an integer value. It won't have a leading zero. You can always convert the integer to a character string and add the leading zero. Here is one method.

replace(str(month(getdate()), 2), ' ', '0')

month(getdate()) is equivalent to datepart(month,getdate()) Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/programmer.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.

 

[mwolf00]

Datepart returns integers '01' will always be 1.

SELECT CASE
WHEN datePart(mm,getDate())< 10 THEN '0' + cast(datepart(mm,getDate()) as char(1))
ELSE cast(datepart(mm,getDate()) as char(2))
END -----------------------------------------------------------------
Be nice. It's only doing what you tell it to do.
mikewolf@tst-us.com

 

[timscronin]

Double thanks