Need month and day WITH leading zero 2

[bigfoot]

When I use Month('07/01/2006') it returns 7
When I use DatePart(mm,'07/01/2006') it returns 7

I'd like 07, and the day 01 because I need to format it on the fly in a query because I'm taking todays date and compairing it against a field that
looks like this -> '#2006\07\06\DOCxyz'

Yes I know the slashes are reversed in the table. It's not my table.


(help... please)

 

[gmmastros]

Month and Datepart return integers, so you would have to convert it to varchar and pad it with a zero.

Select Right('0' + Convert(VarChar(2), Month(GetDate())), 2)

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[bigfoot]

WOW! I've been looking at this for more then an hour!

Thanks so much.

My problem was I was not taking the right 2 characters!
I wound up with 3 characters when 10,11, or 12.

Thanks again

 

[bborissov]

SELECT REPLACE(CONVERT(varchar(10),GETDATE(),111),'/','\')+DOCxyz'

Borislav Borissov
VFP9 SP1, SQL Server 2000/2005.

 

[bigfoot]

Interesting answer bborissov.
I had forgot all about Replace.

Thanks to both of you.