Format equivalant function in sql server 2008

Question

Format equivalant function in sql server 2008

JoyKing

Ten Centuries

Points: 1106
More actions
September 11, 2013 at 2:43 am

#277957

Team,
I have used format function sql server 2012 to get month number as "09"
select format(dateadd(m,-11,'2013-08-01'), 'MM')
Could you please help me to get same output in SQL server 2008.
Thanks in advance,
Keerthy

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

ChrisM@Work SSC Guru Points: 186127 More actions · Answer 1

DATEPART() or MONTH(). Both return INT so you may need to CAST.

^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}

For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

JoyKing Ten Centuries Points: 1106 More actions · Answer 2

Thanks for your quick reply, but we can use cast / convert only after applying datepart function.

It would be great, if you could able send test script.

ChrisM@Work SSC Guru Points: 186127 More actions · Answer 3

JoyKing (9/11/2013)
Thanks for your quick reply, but we can use cast / convert only after applying datepart function.
It would be great, if you could able send test script.

Yes, but if you were thinking of using CONVERT, then you would do it like this:

SELECT CONVERT(CHAR(2),GETDATE(),10)

^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}

For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

ChrisM@Work SSC Guru Points: 186127 More actions · Answer 4

Better still, using your example:

SELECT CONVERT(CHAR(2),DATEADD(m,-11,'2013-08-01'),10)

^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}

For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden