select convert(varchar,columnname,101) from tablename

How can u convert the Date to String?

Question Posted / prasad

Answer Posted / prasad

Is This Answer Correct ?

11 Yes

2 No

Please Help Members By Posting Answers For Below Questions

How to return the date part only from a sql server datetime datatype?

583

application server is slow what may be the problem

1786

What is rank function?

606

How to see the event list of an existing trigger using sys.trigger_events?

573

How to execute the cursor queries with "open" statements?

618

How many types of cursor type are there?

591

What are the characteristics of modern DBMS?

626

What is dbcc?

737

Can we add a cpu to sql server?

526

Describe how to use the linked server?

608

What is use of except clause?

633

What are user-defined functions (udfs) in sql server?

574

What are entities and relationships?

562

How do I completely remove sql server instance?

571

Can another user execute your local temporary stored procedures?

547