Converting date to format mm/yyyy 1

[MattSmithProg]

Hi,

I am attempting to convert a datetime column to the format mm/yyyy. At present I have this

SELECT

CAST(Month(getDate()) AS CHAR(2)) + "/" + CAST(YEAR(getDate()) AS CHAR(4))

However this returns 8/2002 but I want 08/2002. Is there any way to get the month to return a zero at the start if the current month is only a single integer?

Thanks for your help Matt Smith

No two nulls are the same

 

[tlbroadbent]

This works.

Select right(convert(varchar(10),getdate(),103),7) Terry L. Broadbent - DBA
Computing Links:

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

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

 

[MattSmithProg]

Thanks Terry

I wouold give you a star but my browser does not support scripting. Matt Smith

No two nulls are the same

 

[SQLBill]

Matt,

I gave him the star for you.

-SQLBill

 

[SQLBill]

OOOPPPPSSSS, I meant to add because I was able to use the solution also.

-SQLBill