<div>
OR<br />
<br />
select datename(MM,getdate()) +' ' + Convert(varchar,datepart(d<wbr />d,getdate(<wbr />))) + ', ' + Convert(varchar,datepart(y<wbr />ear,getdat<wbr />e()))
</div>


OR

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

<div>
Awesome! &nbsp;Thank you very much!
</div>


<div>
or to get it with the 2-digit day <br />
<br />
SELECT datename(MM,getdate()) + ' ' + SUBSTRING(CONVERT(VARCHAR(<wbr />8), GETDATE(), 3), 4, 2) +', ' + Convert(varchar,datepart(y<wbr />ear,getdat<wbr />e()))
</div>


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()))

<div>
<div class="content wysiwyg-content">
Experts-<br />
<br />
I am using the following query to grab a column in my db and convert the date. &nbsp;I would like the full month to display if possible. &nbsp;Currently, what I have is only displaying three characters in the month along with the day and year. &nbsp;Any help would be appreciated<br />
<br />
&nbsp;SELECT CONVERT(VARCHAR(12), nextBillingDate_c, 107) AS [Month DD, YYYY]<br />
&nbsp; FROM members<br />
<br />
Thanks
</div>
</div>


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

Convert Date

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.