asked on 9/8/2011

Convert Date

Experts-

I am using the following query to grab a column in my db and convert the date. I would like the full month to display if possible. Currently, what I have is only displaying three characters in the month along with the day and year. Any help would be appreciated

SELECT CONVERT(VARCHAR(12), nextBillingDate_c, 107) AS [Month DD, YYYY]
FROM members

Thanks

Microsoft SQL Server 2008

Last Comment

OriNetworks

9/8/2011

ASKER CERTIFIED SOLUTION

OriNetworks

9/8/2011

THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

OriNetworks

9/8/2011

OR

select datename(MM,getdate()) +' ' + Convert(varchar,datepart(dd,getdate())) + ', ' + Convert(varchar,datepart(year,getdate()))

nmarano

9/8/2011

ASKER

Awesome! Thank you very much!

OriNetworks

9/8/2011

or to get it with the 2-digit day

SELECT datename(MM,getdate()) + ' ' + SUBSTRING(CONVERT(VARCHAR(8), GETDATE(), 3), 4, 2) +', ' + Convert(varchar,datepart(year,getdate()))