Month to 2 digits

[corbinap]

How do I convert the month to return a 2 digit month - not 1????

Declare @LastMonth varchar(2)
SET @LastMonth = convert(varchar(2), Datepart(mm,getdate())-1);
select @LastMonth

 

[kaht]

Here's one way:

Declare @LastMonth varchar(2)
SET @LastMonth = [!]right('00' + [/!]convert(varchar(2), Datepart(mm,getdate())-1)[!], 2)[/!];
select @LastMonth

-kaht

Lisa, if you don't like your job you don't strike. You just go in every day and do it really half-assed. That's the American way. - Homer Simpson
[small]<P> <B> <P> <B> <P> <B> <P> <B> <P> <B> <P> <B> <P> <B> <P> <B> <P> <B> <P> <B> <P> <B> <P> <B> <P> <B> <P> <.</B> bites again.[/small]

 

[corbinap]

Thanks

 

[corbinap]

But, I also need to add the 4 digits year in the front: yyyymm

Declare @LastMonth varchar(2)
SET @LastMonth = right('00' + convert(varchar(2), Datepart(mm,getdate())-1), 2);
select @LastMonth

 

[ca8msm]

Just apply the same logic that kaht gave you but use the year in the DatePart function...


-------------------------------------------------------

Mark,
[URL unfurl="true"]http://aspnetlibrary.com[/url]
[URL unfurl="true"]http://mdssolutions.co.uk[/url] - Delivering professional ASP.NET solutions
[URL unfurl="true"]http://weblogs.asp.net/marksmith[/url]

 

[PDreyer]

select lastmonth=convert(varchar(6),dateadd(mm,datediff(mm,0,getdate())-1,0),112)

 

[PDreyer]

Actually, since we ignore the day part:
select lastmonth=convert(varchar(6),dateadd(mm,-1,getdate()),112)

 

[corbinap]

thanks...