[Solved] Show Date as dddd Mmmm d, yyyy SQL

by


Use the following with DateName and convert functions :

select DateName( month , q.dt )+' '+convert(char,day(q.dt))+', '+convert(char,year(q.dt))
  from        
     (
      select convert(date,'20180802') as dt
     ) q;

SQL Fiddle Demo

With respect to your last comment make your query as :

select DateName( weekday , q.dt )+' '+
       DateName( month , q.dt )+' '+
       convert(char,day(q.dt))+', '+convert(char,year(q.dt)) as "Date"
  from        
     (
      select convert(date,'20180802') as dt
     ) q;

Date
------------------------
Thursday, August 2, 2018

13

solved Show Date as dddd Mmmm d, yyyy SQL