Converting Date to String in SQL Server 2005

Question

I am working on SQL server 2005. While inserting specified date in the database by this format:
(10/11/2012 00:00:0:00)(MM/dd/yyyy HH:mm:s:ms).

select CAST(day(column name) AS CHAR(2)) + ' '
   + CONVERT(CHAR(4), column name, 100) + ', '
   + CONVERT(CHAR(4), column name, 120) as Coupon_expire
from Admin

I can't convert this date to this type (Wednesday, October 11, 2012), please help me.

RichardTheKiwi · Accepted Answer · 2012-10-26 05:54:13Z

1

SELECT  DATENAME(weekday,'10/11/2012')
      + ', '
      + DATENAME(month,'10/11/2012')
      + ' '
      + convert(varchar,month('10/11/2012'))
      + ', '
      + convert(varchar,year('10/11/2012'))

Try this.

edited Oct 26, 2012 at 5:54

RichardTheKiwi

108k28 gold badges206 silver badges269 bronze badges

answered Oct 26, 2012 at 5:48

Annie

6721 gold badge7 silver badges21 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

t-clausen.dk Over a year ago

+1 for a good solution, one minor detail. In my opinion, instead of using default length, you should always specify the length of the varchar.

Collectives™ on Stack Overflow

Converting Date to String in SQL Server 2005

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related