Convert Date to a string

Question

Post reply

Convert Date to a string

Matthew Waugh

Grasshopper

Points: 14
More actions
November 22, 2004 at 1:14 pm

#59737

How do I pull the month out of date, and convert it to a string value?
In other words, if the month is January, I want to pull out 01. February, I want 02 (but the output needs to be a string)

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

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

Osoba SSCommitted Points: 1964 More actions · Answer 1

select case when datepart(mm,getdate())<=9 then '0'+cast(datepart(mm,getdate())as varchar)

else cast(datepart(mm,getdate())as varchar) end

noeld SSC Guru Points: 96590 More actions · Answer 2

OR:

select right('00'+ cast(month(getdate()) as varchar(2)),2)

* Noel

Frank Kalis SSC Guru Points: 111183 More actions · Answer 3

Another one:

SELECT REPLACE(STR(DATEPART(mm,GETDATE()),2), ' ', '0')

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

Robert Stewart Hall of Fame Points: 3399 More actions · Answer 4

And, a totally different idea...

Create a table that has all the date conversions done, a dimension table. Then simply link to the table and pull only the month converted to text. By using a table, you essentailly never have to do any date conversions like this again.